how can I change case to Proper on a worksheet

[PlsHelp]

I have an excel file that is all caps and want to change the case to proper

 

[JE McGimpsey]

Take a look here:

http://www.mvps.org/dmcritchie/excel/proper.htm

 

[rosalindvt]

You can also export to a .CSV, open the .CSV in MS Word, Use "Change Case" to
change to Title Case, and then re-import into Excel.