converting to mixed case
 

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

--
antr
-----------------------------------------------------------------------
antro's Profile: http://www.excelforum.com/member.php...fo&userid=1577
View this thread: http://www.excelforum.com/showthread.php?threadid=27370

converting to mixed case
 

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