How can I cange text to lowercase in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have some imported data that came in all caps. Is there anyway to change
the data to upper and lower case?
 
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
 
Back
Top