Separate date in Excel Field

I have a field in Excel that has both first name and last name separated by a space. I would like to pull out only the first name into a new column. Is there a formula that will do this?

Here is what the data looks like:
Joe Smith
Randy Roberts
Carl Heinz
Harold Harrison
LVL 5
Mark GrondinAsked:
Who is Participating?
 
SreeramConnect With a Mentor Commented:
Try This :

  =IFERROR(LEFT(F10,FIND(" ",F10)-1),F10)
0
 
CraigFrostCommented:
Select the data you want to modify --> Select the Data tab --> select Text to columns --> Select delimited --> Next --> Select "Space" only --> Select Finish
0
 
Rgonzo1971Connect With a Mentor Commented:
Hi,

the formula would be

=LEFT(A1,FIND(" ",A1)-1)

Open in new window

and for the last name if first name is in B1
=RIGHT(A1,LEN(A1)-LEN(B1)-1)

Open in new window

Regards
0
 
Mark GrondinAuthor Commented:
Thank you for your help. =IFERROR(LEFT(F10,FIND(" ",F10)-1),F10) helped me deal with the exceptions, and I ended up using both the codes for first and last names (adding the "IFERROR" function to the lastname funciton suggested). I also returned a blank instead of the original contents of the cell, so my final functions I used are:
first name: =IFERROR(LEFT(L2,FIND(" ",L2)-1),"")
last name: =IFERROR(RIGHT(L2,LEN(L2)-LEN(V2)-1),"")

Wasn't exactly sure how to use the first recommendation, so I can not confirm how it works.

Thanks for your help!
0
 
Mark GrondinAuthor Commented:
Requested help to get the points correctly divided...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.