View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo
 
Posts: n/a
Default formula for changing CAPS to small letters

=proper(a1)

HTH
regards from Brazil
Marcelo

"Stilla" escreveu:

Hello...

Is there a formula I can use to turn two columns of names (first & last)
that are currently in Capital letters, into small letters with only the first
letter in Caps?

Thanks in advance!

Stilla