Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I need to convert name 3 part name into Last, First MiddleNameorMI
I have a column of names, most of which are FirstName LastName in format.
Some, however are First MiddleName (or MI) Last. I need to convert these values into LastName Firstname MI. I have a formula that gets close, but doesn't account for the possible presence of a Middle Name or initial. For ex, data could be Jill Smith, or Jo Ann Smith. I need to make Smith, Jill and Smith, Jo Ann. Seems like I need to go backwards thru the string with a Search function to find the 2nd space for this to work, but can't. Or should I try it by parsing consecutive columns with incremental changes together???? Help! Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Must convert 500+ xls files to txt (tsv) | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Still Convert Lotus 123 to Excel 2003 | Excel Discussion (Misc queries) | |||
Convert Time...!convert tenths of a second | Excel Discussion (Misc queries) | |||
convert excel list to pivot table | Excel Discussion (Misc queries) |