Hi
use
=PROPER(A1)
in an adjacent cell

--
Regards
Frank Kabel
Frankfurt, Germany


antro wrote:
does anyone know how to automatically convert text in a cell to mixed
case? i.e., I have a list of names that were entered in all caps, but
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 of each word in lowercase.

Thanks in advance for the help

Antro