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