Hi
see:
http://www.cpearson.com/excel/case.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"dumbfounded" schrieb im
Newsbeitrag ...
I have a spreadsheet containing data to make mailing labels. The
whole thing
was entered in caps. I need to change it to the Proper style ( the
first
letter is capitalized and the rest lower case). How can I do this?