How to Split Names with Comma in Excel: 3 Suitable Methods

Method 1 – Split Names with Comma Using Text to Columns in Excel

Steps:

• Select all the cells containing cells separated by a comma. In this example, the range of cells is B5:B8.

• Now, in your ribbon, go to the Data tab.
• Under the Data Tools group, select Text to Columns.

• A Convert Text to Column Wizard will pop up. Check Delimited in the first window and click Next.

• Check Comma under Delimiters. Click on Next.

• Select the destination where you want to place your separated column. We selected cell $C$5.

• Click Finish.
• There is an error warning; click OK.

You will have your first name, middle name, and last name separated.

Method 2 – Utilizing Flash Fill to Split Names with Comma

Steps:

• Fill out the first names. Select a cell and manually type in the first name of the first entry.

• Start typing out the first name for the next entry. The Flash Fill feature will automatically suggest the rest of the first names.

• Once the names are suggested, press Enter on your keyboard. You will have your first names separated.

• Fill out the middle name and last name column by repeating the process. You will have your names split.

Method 3 – Applying Different Formulas in Excel

3.1 Split First Name

Steps:

• Select the cell where you want the first name. It is cell C5.
• Write down the following formula in the cell.

• Press Enter on your keyboard. You will have your first name separated from the cell.

• Select the cell again and click and drag the Fill Handle Icon to the end of the list to get all the first names from the list.

Have your first names split with a comma using the formula in Excel.

3.2 Split Middle Name

Steps:

• Select the cell where you want to split out the middle name. It is cell D5.
• Write down the following formula in the cell.

• Press Enter on your keyboard. You will have the middle name extracted from cell B5.

• Select the cell again. Click and drag the Fill Handle Icon to the rest of the column to fill it out with middle names.

This will split middle names in Excel with comma.

3.3 Split Last Name

Steps:

• Select the cell where you want to write the last name. We selected cell E5 for this.
• Write down the following formula.

• Press Enter on your keyboard. You will have the last name from cell B5.

• Click and drag the Fill Handle Icon to fill out the formula for the rest of the column.

You will have split names in Excel with a comma for the last names.

Download Practice Workbook

Related Articles

• How to Split Names into Three Columns in Excel
• Separate First and Last Name with Space Using Excel Formula
• How to Split Names Using Formula in Excel