Formatting existing data in a table column
I have a column of data that was imported from an excel spreadsheet that is formatted in a mish-mash of capitalized text entries and non-capitalized.
What's the easiest way to format the information in the same manner? I found the Proper() function...do I just have to use a looping script? Is there a way at the import step to perform a check?