How To Separate Names In Microsoft Excel And Google Sheets

In the event you’re utilizing Microsoft Excel, you possibly can separate names utilizing the Convert Textual content to Columns Wizard. Here is how you can use the software within the desktop app:

1. Open the Excel sheet and choose the column that accommodates the names you need to separate.

2. Click on on Knowledge on the high and choose Textual content to Columns.

3. Within the Convert Textual content to Columns Wizard, choose Delimited beneath file kind.

4. Click on Subsequent.

5. Select the suitable Delimiters. This may very well be a comma or area, relying in your formatting.

6. A preview will present you what the separated names will appear to be. Click on Subsequent.

7. Subsequent to Vacation spot, click on on the arrow and select the column the place you need the separated names to look.

8. Click on End.

In the event you’re utilizing the free on-line model of Excel, use this methodology as a substitute:

1. Choose the column with the names you need to separate.

2. Click on Knowledge and choose Textual content to Columns.

3. Choose your Delimiters corresponding to commas or areas.

4. A preview will seem on the display.

5. Click on Apply.

6. The names will mechanically separate into the chosen column and the one subsequent to it.

If there aren’t any empty columns, Excel will warn you that it’s going to substitute the textual content within the column to the best. Subsequently, it is best to be sure you have an empty column subsequent to the record of names to keep away from shedding any information.