Ronald, use the proper function, like this, =PROPER(A1) than you can copy
and paste special valves back over you data
--
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

"Ronald_L" wrote in message
...
I have a row of approx 3000 names that are in all uppercase. The are in
the
format of FirstName LastName. How can I set a formula to leave only the
first character of the first and last name in uppercase and the rest
lowercase. Such as John Doe instead of JOHN DOE.