As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

Splitting Names in Excel: A Quick and Easy Guide

If you're dealing with a list of names in an Excel spreadsheet and need to separate them into distinct first and last name columns, there's a straightforward solution. Follow this step-by-step guide on how to split names in Excel.

Step 1: Select the Column with Names

Begin by selecting the column containing the names you wish to split. Click on the column header, which is the letter at the top of the column.

Step 2: Go to the Data Tab and Click "Text to Columns"

Navigate to the Data tab on the Excel ribbon. Locate and click on the "Text to Columns" button. This action will open the Convert Text to Columns Wizard.

Step 3: Choose the "Delimited" Option and Click Next

In the Convert Text to Columns Wizard, opt for the "Delimited" option, and then click Next. This informs Excel that you want to split the text based on a specific delimiter.

Step 4: Select the Delimiter and Click Next

Select the delimiter that will be used to split the names. The common choice is a space, but commas, semicolons, or other characters can also be used. In this guide, a space will be used as an example.

Step 5: Choose How to Split the Text and Click Finish

Now, choose how you want to split the text. The standard option is to split it into multiple columns, but you can also opt to split it into rows. For this guide, the choice is to split it into multiple columns.

Step 6: Choose Where to Place the Split Text and Click OK

Finally, determine where you want to place the split text. You can either put it in the same column or allocate it to a new column. In this example, the decision is to place it in a new column.