Hi,

I have received an Excel spreadsheet with about 20,000+ rows x 6 columns, and in a few of the columns in the spreadsheets are names of people or companies, all in ALLCAPS (e.g. MICROSOFT CORPORATION, COMPUTER ASSOCIATES, INC., etc).

I want to reformat them to "CapOnlyForFirstLetter", such as Microsoft Corporation, and Computer Associates, Inc., in the foregoing examples.

Is there an easy way to do that. It'll save me a lot of re-keying (big waste of time) !

Appreciate your help.