converting to mixed case

[antro]

does anyone know how to automatically convert text in a cell to mixe
case? i.e., I have a list of names that were entered in all caps, bu
when I import them into a Word report, the caps mess up the formatting
I need to keep the first letter of each word uppercase, but the rest o
each word in lowercase.

Thanks in advance for the help

Antr

 

[Frank Kabel]

Hi
use
=PROPER(A1)
in an adjacent cell