How to Split Full Name into First Name, Middle Name and Last Name in Excel

Показать описание

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.

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.

-----------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------

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 Case playlist:

Connect us on social media