Working with Strings

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

[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!

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.

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

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