21/03/2023
Separate First Middle and Last name in Excel
For First Name:
=TRIM(LEFT(SUBSTITUTE(A2," ",REPT(" ",99)),99))
For Middle Name:
=IFERROR(MID(A2,FIND(" ",A2)+1,FIND(" ",A2,FIND(" ",A2)+1)-1-FIND(" ",A2)),"")
For Last Name:
=TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",99)),99))