Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Working with Strings
I have a column which has names. I would like to split it by Last, First and
Middle Names. Can some one help me do it. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Working with Strings
You can use Text to Columns: DataText to Columns. Assuming there is a space between names, choose "delimited" and "space" when running the wizard. You will probably have to "clean up" a bit with a few names that have "Jr.", etc. Hope it helped! joe Wrote: I have a column which has names. I would like to split it by Last, First and Middle Names. Can some one help me do it. -- kevindmorgan ------------------------------------------------------------------------ kevindmorgan's Profile: http://www.excelforum.com/member.php...o&userid=32232 View this thread: http://www.excelforum.com/showthread...hreadid=520266 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Working with Strings
Depends on the format of the names. Here are two examples that might help
you. If you need something else, then list how the names are inputted. John Joe Smith - Can be seperated with Date-Text To Columns. Select Delimited, and then select a space as the delimiter. - You can also use helper columns with the following formulas =LEFT(A1,FIND(" ",A1)-1) =MID(A1,FIND(" ",A1)+1,FIND(" ",A1,FIND(" ",A1)+1)-FIND(" ",A1)-1) =RIGHT(A1,LEN(A1)-FIND(" ",A1,1+FIND(" ",A1))) Smith, John Joe - Can be seperated with the following formulas =LEFT(A1,FIND(",",A1)-1) =MID(A1,FIND(" ",A1)+1,FIND(" ",A1,FIND(" ",A1)+1)-FIND(" ",A1)-1) =RIGHT(A1,LEN(A1)-FIND(" ",A1,1+FIND(" ",A1))) If you use the formulas, you can copy and paste special selecting values. This will replace the formulas with the result of the formulas. "joe" wrote: I have a column which has names. I would like to split it by Last, First and Middle Names. Can some one help me do it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
amount of working days per month | Excel Discussion (Misc queries) | |||
Calculation with Working day of the year | Excel Discussion (Misc queries) | |||
Working days left in the month compared to previous months | Excel Worksheet Functions | |||
Working time and days | Excel Worksheet Functions | |||
Working time and days | Excel Discussion (Misc queries) |