uppercase to lowercase

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?

=PROPER(A1)

--

HTH

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


"Missy" <[email protected]> wrote in message
news:[email protected]...
> 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?