Separate names into columns

[Carter]

I have a column that has first and last name or it may have first, middle and
last name. I need to know how to pull the first name in a separate column
and also pull the last name into another column. I need to know how to
ignore the middle name, if applicable.

 

[Teethless mama]

Try this:

First name:
=LEFT(A1,FIND(" ",A1)-1)

Last name:
=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",99)),99))

 

[Jacob Skaria]

Bit lengthy to handle entries with first names alone...

First name ()
=LEFT(A12,FIND(" ",A12 & " ")-1)

Last name
=IF(ISERROR(FIND(" ",A12)),"",TRIM(RIGHT(SUBSTITUTE(A12," ",REPT("
",99)),99)))

If this post helps click Yes

 

[Carter]

This worked perfectly. Thanks! Shelia

Try this:

First name:
=LEFT(A1,FIND(" ",A1)-1)

Last name:
=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",99)),99))