You are currently viewing Excel: How to split names

Excel: How to split names

Microsoft Excel has a plethora of uses in information processing. It can safely store data, including names, contact numbers, contact addresses, etc.

When working on your Excel, you may wish to split full names into first and last names. Sometimes, you may include the middle name. But how do we go about this? You can do this via many methods:


Split Names Using Text to Columns

By using this function, you will be able to split the values of the text in a column into separate cells.

Now, let's split the names in the images below into first and last names:

  • Check column (A2: A10) and select all the names.
  • Check the Data tab and click the tab with the label 'Data.'
  • Under the "Data" option, scroll down till you get to an option with the tag – "Text to columns." Click on it.

Now, navigate the cursor to the "convert text to column" Wizard and follow the straps below:

Step 1: Hover your cursor on "delimited", then you proceed to column wizard and click "NextSelect Delimited."

Step 2: Move the cursor to "space option' and click "NextSelect." "NextSelect" serves as the space option.

Step 3: Choose the destination cell. The existing cell can overwrite if you fail to choose the destination cell.

Click finish, and the names will be split into two columns.


Separate names using formula

You can also split names on your excel using formula. This is a very quick and efficient method.

Choose an empty column and name it "the first name." Type the formula =LEFT(A2, FIND(" ", A2,1)-1) in the cell you want to split it to. We choose B2 in this case




Choose another empty column and name it "The last name." Type the formula =RIGHT(A2,LEN(A2)-FIND(" ",A2,1)). The second or last name will be split into this cell, here it will be C2.



Within a blink, the names will be split. The two columns will be filled with the first names and last names.



These two methods are great time savers. I hope this tutorial is helpful to you. Don't keep it to yourself; please share this post with your friends.