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

"Brent" wrote in message
...
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?