| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
changing the order of text in a string
Using Excel 2003, I have a column of names, in the format
John Smith Henry A. Jones Maryanne George Mary Ann George I need to reverse the order, to be lastname, firstname +middle(if present) Thus I get Smith, John Jones, Henry A. etc. How can I extract all the characters starting at the right side, to the first space, and move that to the left, followed by a comma. Pepper |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How stop Excel file UK date order changing to US order in m.merge | Excel Discussion (Misc queries) | |||
| changing text values to a different string | Excel Worksheet Functions | |||
| changing numbers in a text string in a new cell | Excel Discussion (Misc queries) | |||
| Changing text order | Excel Discussion (Misc queries) | |||
| Changing a specific character type in text string | Excel Discussion (Misc queries) | |||
Threaded Mode
