Working with Strings

J

joe

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.
 
K

kevindmorgan

You can use Text to Columns: Data>Text 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!
 
S

Sloth

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.
 
Top