formula for changing CAPS to small letters
 

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

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

formula for changing CAPS to small letters
 

Stilla wrote:
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


Hi Stilla,

you can use the PROPER function.

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy