Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Change Case from Mixed to Caps | Excel Discussion (Misc queries) | |||
Converting upper case to lower case | Excel Discussion (Misc queries) | |||
How to change mixed case to upper case in Excel for all cells | Excel Discussion (Misc queries) | |||
Question about comparing mixed case string values | Excel Programming | |||
Problem with copying variable(s) to cell(s) and converting strings to mixed case | Excel Programming |