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