ExcelBanter - uppercase to lowercase

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - uppercase to lowercase (https://www.excelbanter.com/excel-worksheet-functions/11490-uppercase-lowercase.html)

Missy

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?

Bob Phillips

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

All times are GMT +1. The time now is 06:42 AM.