Tip Printed from ExcelTip.com

---

Separating First and Last Names Using Formulas


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.