» Separating First and Last Names Using Formulas

CATEGORY - Excel Editing VERSION - All Microsoft Excel Versions

To separate the name John Smith, in cell A1, use two formulas:

The formula that extracts the first name is:

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

The formula that extracts the last name is:

=MID(A1,FIND(" ",A1)+1,LEN(A1))

The FIND formula returns the starting position of one text string within another text string.
Screenshot // Separating First and Last Names Using Formulas