| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - Parse Name
Thanks!
-- Thanks! Chris "Ron Rosenfeld" wrote: On Sun, 16 Mar 2008 15:35:01 -0700, Chris wrote: I have to parse out names that are not consistent. The data comes in as: Mary Smith John J Smith I want the out to be: Smith John J or Smith Mary. Can anyone help? =MID(TRIM(TRIM(A1)),FIND(CHAR(1),SUBSTITUTE(TRIM(T RIM(A1))," ",CHAR(1), LEN(TRIM(TRIM(A1)))-LEN(SUBSTITUTE(TRIM(TRIM(A1))," ",""))))+1,255)&" "& LEFT(TRIM(TRIM(A1)),FIND(CHAR(1),SUBSTITUTE(TRIM(T RIM(A1))," ",CHAR(1), LEN(TRIM(TRIM(A1)))-LEN(SUBSTITUTE(TRIM(TRIM(A1))," ",""))))-1) would do that. --ron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Parse this string | Excel Discussion (Misc queries) | |||
| Parse from the Right | Excel Worksheet Functions | |||
| How do I parse columns? | Excel Worksheet Functions | |||
| Excel GURUs help. (How to make program parse more than 1 forumla within a cell) | Excel Worksheet Functions | |||
| Q: parse string | Excel Discussion (Misc queries) | |||
Threaded Mode
