=PROPER(A1)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Missy" wrote in message
...
Please tell me how to change all uppercase to first letter only uppercase,
JOHN DOE to John Doe. Can I do a whole worksheet in one try?