Change capitalization

[john9210]

I have imported a large number of records but all the names of individuals are in all caps. I would like to create a calculation field that changes the names to lower case but with the first letter capitlaized. I don't think I would want to run a script to do this unless necessary.

[doughemi]

Try

Proper(AllCapField)

 

[comment]

1 hour ago, john9210 said:

I would like to create a calculation field that changes the names to lower case but with the first letter capitlaized.

The Proper() function will do that, but it will not restore all names to their original form. For example, both Macdonald and MacDonald will now become Macdonald, with no way to tell what the original was.

Note also that instead of adding a calculation field you could use the same field, formatted to display in Title Case. But this would only work for display, not for exports and/or calculations. 

Edited February 1, 2019 by comment