Split First Name & Last Name If Last Name Exists

[Alex501]

Hi

I'm using the following formula to split out the first name from cells that contain first and last name;

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

This works fine, however if the cell only contains a first name I get a #VALUE!, how do I amend the formula so that it returns the first name if that's all the cell contains?

Thanks

 

[Sanjeev1976]

You can try :

=IF(ISERR(FIND(" ", A2,1) ),A2,LEFT(A2, FIND(" ", A2,1) -1))

 

[Alex501]

You can try :

=IF(ISERR(FIND(" ", A2,1) ),A2,LEFT(A2, FIND(" ", A2,1) -1))

Hi Sanjeev, that works perfectly. Thanks for your help.

 

[Phuoc]

A little shorter:

=LEFT(A2,FIND(" ",A2&" ",1)-1)

 

[Alex501]

A little shorter:

=LEFT(A2,FIND(" ",A2&" ",1)-1)

Thanks Phuoc, I might even remember that.

 

[Peter_SSs]

If you are using your 365 version, a little shorter again
=TEXTBEFORE(A2," ",,,1)