Separate first and last name in Excel

02.Aug.2014

Assuming that we have column A containing first and last name with a potential middle name, we can assume that taking first name can be conducted by getting the value from beginning until first space.

Getting the first name:

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

Slightly more complex formula goes for the last name:

=MID(A2,FIND(CHAR(1),SUBSTITUTE(A2," ",CHAR(1),LEN(A2)-LEN(SUBSTITUTE(A2," ",""))))+1,LEN(A2))