Thread: Formula for changing all caps to lower case
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default Formula for changing all caps to lower case
=PROPER(A2)


Regards,


Peo Sjoblom


"PFLY" wrote:

Is there a formula that I can use to change LIMA OHIO to Lima Ohio, just the
first letters being in Caps and the rest in lower case?
Reply With QuoteReply With Quote