[RESOLVED] Changing from ALLCAPS to CapOnlyForFirstLetter in Excel 2000 on WinXP

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.

Excel doesn't have the ability.
MS Word does...Format-> Change Case

Maybe you can copy n paste back n forth.

Excel 2003 can do this, though I'm not sure if Excel 2000 can. The formula is Proper. So if A1 says MICROSOFT CORPORATION, define B1 to be (without quotes)

"=PROPER(A1)"

You can also use the code UPPER and LOWER. PROPER means first letter in caps.

Thank you all for your advice, I copied the Excel book into Word, and then formated, and copied back into Excel. All the text effects I wanted are in Excel very successfully.