formula for changing CAPS to small letters

[Guest]

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

 

[Guest]

=proper(a1)

HTH
regards from Brazil
Marcelo

"Stilla" escreveu:

 

[Franz Verga]

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