Changing word case in Excel doc

[Guest]

I have an Excel doc in which some words appear in all caps; others all lower
case; and other done properly. How do I quickly change the case writing in
the entire doc to proper?

 

[Paul B]

Brent, have a look here for a macro to do it

http://www.xcelfiles.com/VBA_Quick16.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Guest]

You can also save as a .CSV and then open it in MS Word. Use the "Change
Case" format option to change to title case (or whatever case you choose.)
Save the file again, and then re-import into Excel.