Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How To Remove all caps in column?
In My spread sheet I have a list of names but they are all in caps... That was great for an envelope but not so good when I am going to do a letter merge. How do you remove or format the names so they are not all caps? Can you do that? Obviously I would still need the first letter to be capitalized but not the whole name. Any help would be greatly appreciated, I am stuck and do not want to type out every name .. I have excel 2002 and access 2002 and I cant seem to find out how to change this Sam -- fastblogs ------------------------------------------------------------------------ fastblogs's Profile: http://www.excelforum.com/member.php...o&userid=35118 View this thread: http://www.excelforum.com/showthread...hreadid=548727 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i multiply two columns | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
match and count words | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |