How To Separate Names In Microsoft Excel And Google Sheets

If you’re using Microsoft Excel, you can separate names using the Convert Text to Columns Wizard. Here’s how to use the tool in the desktop app:

1. Open the Excel sheet and select the column that contains the names you want to separate.

2. Click on Data at the top and select Text to Columns.

3. In the Convert Text to Columns Wizard, select Delimited under file type.

4. Click Next.

5. Choose the appropriate Delimiters. This could be a comma or space, depending on your formatting.

6. A preview will show you what the separated names will look like. Click Next.

7. Next to Destination, click on the arrow and choose the column where you want the separated names to appear.

8. Click Finish.

If you’re using the free online version of Excel, use this method instead:

1. Select the column with the names you want to separate.

2. Click Data and select Text to Columns.

3. Select your Delimiters such as commas or spaces.

4. A preview will appear on the screen.

5. Click Apply.

6. The names will automatically separate into the selected column and the one next to it.

If there are no empty columns, Excel will warn you that it will replace the text in the column to the right. Therefore, it’s best to make sure you have an empty column next to the list of names to avoid losing any data.