Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Field Character Changes
I have a row of approx 3000 names that are in all uppercase. The are in the
format of FirstName LastName. How can I set a formula to leave only the first character of the first and last name in uppercase and the rest lowercase. Such as John Doe instead of JOHN DOE. |
#2
|
|||
|
|||
Ronald, use the proper function, like this, =PROPER(A1) than you can copy
and paste special valves back over you data -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Ronald_L" wrote in message ... I have a row of approx 3000 names that are in all uppercase. The are in the format of FirstName LastName. How can I set a formula to leave only the first character of the first and last name in uppercase and the rest lowercase. Such as John Doe instead of JOHN DOE. |
#3
|
|||
|
|||
Ronald
Note on PROPER() Function. If you have names with Mc or Mac or like van der Meer PROPER() won't do the trick. You will wind up with Mcdonald or Van Der Meer. David McRitchie has VBA code that will look after many of these. http://www.mvps.org/dmcritchie/excel/proper.htm Gord Dibben Excel MVP On Mon, 31 Jan 2005 11:23:18 -0500, "Paul B" wrote: Ronald, use the proper function, like this, =PROPER(A1) than you can copy and paste special valves back over you data |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
Searching a cell for a certain character. | Excel Worksheet Functions | |||
15 character field truncating | Excel Discussion (Misc queries) | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
How do link to a remote field but use the path from a stored field | Excel Discussion (Misc queries) |