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

=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

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