To split first name and last name:

Separate First name: =LEFT(A1,FIND(" ",A1,1)-1)

Separate Last name: =RIGHT(A1,LEN(A1)-FIND(" ",A1,1))

Tagged:

Leave a Reply

Your email address will not be published.


*