=PROPER(A1)

--

HTH

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


"Missy" <Missy@discussions.microsoft.com> wrote in message
news:A136C7AD-F48E-484C-9E6E-73758FB94D38@microsoft.com...
> 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?