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
Join Our WhatsApp Group
Nazim Khan (Author) 📞 +91 9536250020
[MBA in Finance]
Nazim Khan is an expert in Microsoft Excel. He teaches people how to use it better. He has been doing this for more than ten years. He is running this website (TechGuruPlus.com) and a YouTube channel called "Business Excel" since 2016. He shares useful tips from his own experiences to help others improve their Excel skills and careers.
