How to Split Full Name into First Name, Middle Name and Last Name in Excel?
In the previous video i showed how to split full name to first name and last name.
Here is the link: [ Ссылка ]
Now what if your data has first name, middle name and last name?
This is something I need frequently. I run email campaign and splitting names is really important for me. There are numerous other situation where you might need to extract first, middle or last names in excel.
This is actually splitting text into column. I will be using excel formula to split names and I am using Microsoft excel 2010 for the demonstration. Let’s get started.
-----------------------------------------------------------------------------------------------------------
Support Us: [ Ссылка ]
-----------------------------------------------------------------------------------------------------------
Step 1: Write the full name in column A
Step 2: Write this formula in Column B to extract first Name. Here is the formula for first name:
=LEFT(A2,SEARCH(" ",A2))
Step 3: Write this formula in Column C to extract middle Name. Here is the formula for middle Name:
=MID(A2,SEARCH(" ",A2,1)+1,SEARCH(" ",A2,SEARCH(" ",A2,1)+1)-SEARCH(" ",A2,1))
Step 4: Write this formula in Column C to extract last Name. Here is the formula for last Name:
=RIGHT(A2,LEN(A2)-SEARCH(" ",A2,SEARCH(" ",A2,SEARCH(" ",A2)+1)))
Done. You just Split full name to first name column, middle name column and last name column in excel 2010. Hope you like it.
#excel10tutorial #splitnames
Thanks for watching.
If you like this tutorial, please subscribe:
[ Ссылка ]
Checkout our Advance Excel Tutorial Playlist:
[ Ссылка ]
Checkout the Excel tutorial for dummies playlist: [ Ссылка ]
Checkout the Excel Case playlist:
[ Ссылка ]
If you need any specific tutorial you can request that here: [ Ссылка ]
Connect us on social media
Facebook: [ Ссылка ]
Google Plus: [ Ссылка ] *Become a member and enjoy exclusive perks while supporting the channel you love!*
[ Ссылка ]
