How to Split Full Names Into Two Cells in Excel 2013

Properly formatted data can make it much easier to complete tasks in Excel 2013, but it is rare that the data we have is ideally suited for the work that we need to do. This is common when working with names in Excel, as many companies and individuals will store full names in one cell in their spreadsheets, either naturally, or with the aid of the concatenate Excel formula.

Unfortunately this can be problematic when you need a separate cell for the first name and a separate cell for the last name, and the prospect of manually splitting those names is not something that many people would look forward to. Fortunately there is a tool that you can use which will allow you to split first and last names into separate cells in Excel 2013.

Split a Full Name into a First Name and Last Name Cell in Excel 2013

The steps in this article will assume that you currently have a column in Excel 2013 that is storing full names, and that you want to convert that data so that you have a column of first names and a column of last names.

Tip: You will need to have blank cells where you want the split data to go. So it is a good idea to insert the columns before you follow the steps below.

  1. Open the Excel spreadsheet containing the data that you want to split.
  2. Highlight the cells containing the data that you wish to split.
  3. Click the Data tab at the top of the window.
  4. Click the Text to Columns button in the Data Tools section of the ribbon.
  5. Click the Delimited option at the top of the window, then click the Next button.
  6. Check the box to the left of Space, then click the Next button. This assumes that your data is split the same way as it is in this example. If not, then use the appropriate delimiter. For example, if your name was split as LastName, FirstName, then you would check the box next to Comma and the box next to Space. Note that the preview window will adjust as you choose different delimiters.
  7. Click the button at the right side of the Destination field.
  8. Highlight the cells in which you would like the split data to appear, then press Enter on your keyboard.
  9. Click the Finish button at the bottom of the window to complete the process.
click the finish button

Your data should now look like it does in the image below.

split a full name into two cells in excel 2013

Excel also has a helpful function called Concatenate that can do the reverse of this. Learn how to combine data from multiple cells into cell in Excel 2013 and save yourself a lot of manual data entry. newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.