How can I cange text to lowercase in Excel

P

photogirl96

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

Bernard Liengme

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
 
Top