Blog Single

19 Aug

Separating First and Last Names in Microsoft Excel

To pull the First Name use the following formula

=LEFT(A1,FIND(” “,A1,1)-1)

To pull the Last Name use the following formula

=RIGHT(A1,LEN(A1)-FIND(” “,A1,1))

source:Separating First and Last Names in Microsoft Excel.

 

Related Posts