In the below video, i have explained how can you split or separate the names in 3 words, like First Name, Middle Name, and Last Name. In this post, i have provided a sample file download option below. so that you can check the formulas in the Excel file and how i have split the names.
eConvert.org provides a very amazing tool to separate First Name – Middle Name – Last Name by one click, and after splitting the names the provides a copy data option so that you can copy all split names and paste them into your Excel easily.
Formula Used in this Sheet:
=SEARCH(” “,A2)
=LEFT(A2,B2-1)
=RIGHT(A2,D2-B2)
=IFERROR(SEARCH(” “,E2),””)
=IFERROR(LEFT(E2,F2-1),””)
=IFERROR(LEN(E2)-F2,””)
=IF(I2=””,E2,I2)
Tutorial Video