ExcelBanter - How can I cange text to lowercase in Excel

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

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

- - How can I cange text to lowercase in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/118015-how-can-i-cange-text-lowercase-excel.html)

photogirl96

How can I cange text to lowercase in Excel

I have some imported data that came in all caps. Is there anyway to change
the data to upper and lower case?

Bernard Liengme

How can I cange text to lowercase in Excel

Search Help under PROPER and LOWER
A1 is "CAT DIED ON MONDAY, =PROPER(A1) gives "Cat Died On Monday"
while =LOWER(A1) give "cat died on monday"
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"photogirl96" wrote in message
...
I have some imported data that came in all caps. Is there anyway to change
the data to upper and lower case?

All times are GMT +1. The time now is 11:38 AM.