uppercase to lowercase

M

Missy

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?
 
B

Bob Phillips

=PROPER(A1)

--

HTH

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