Thread: How can I cange text to lowercase in Excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default 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?


Reply With QuoteReply With Quote