ExcelBanter - How do I change uppercase to lowercase without re-typing (Excel)

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I change uppercase to lowercase without re-typing (Excel) (https://www.excelbanter.com/excel-discussion-misc-queries/237145-how-do-i-change-uppercase-lowercase-without-re-typing-excel.html)

kellyu

How do I change uppercase to lowercase without re-typing (Excel)

How do I change words from uppercase to lowercase without re-typing the words
completely...
e.g. WORKSITE to Worksite or worksite.
Thanks,
Kelly

Jim Thomlinson

How do I change uppercase to lowercase without re-typing (Excel)

=Upper(A1)
=Lower(A1)
=Proper(A1)

--
HTH...

Jim Thomlinson

"kellyu" wrote:

How do I change words from uppercase to lowercase without re-typing the words
completely...
e.g. WORKSITE to Worksite or worksite.
Thanks,
Kelly

All times are GMT +1. The time now is 08:45 PM.