Skip to main content

how to separate first name, middle name and last name in excel

Simple way to separate FULL NAME to FIRST name, MIDDLE name and LAST name in excel with find, left and id function presented by 99Excel.Com (Akumar)

First Name :        =IFERROR(LEFT(A2,FIND(” “,A2)-1),A2)

Middle Name : =IFERROR(MID(A2,FIND(” “,A2)+1,(FIND(” “,A2,FIND(” “,A2)+1)-FIND(” “,A2)-1)),””)

Last Name :        =IFERROR(IFERROR(MID(A2,FIND(” “,A2,FIND(” “,A2)+1)+1,100),MID(A2,FIND(” “,A2)+1,100)),””)

how to separate first name, middle name and last name in excel

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *