How to Split Names in Google Sheets

When working with Google Sheets, you often get the file that the names are in one column. In Google Sheets, you can separate the names either using the "Split text to columns" feature or the add-on "Split Names" to finish this task. In this article, we use the add-on to demo how to separate names to columns.

1. To Get Add-on

Step 1: Click the "Add-ons" tab from the ribbon and click "Get add-ons" from the drop-down list;

Step 2: In the add-ons page, type "split" in the search box;

Step 3: The add-on "Split Names" should come on the top of the list;

Step 4: Click and install the add-on following the steps, please makes sure you select the proper account if you have multiple Google account logged in;

2. To Split Names

Step 5: Select the data range with the names to split;

Step 6: Click the "Add-ons" tab from the ribbon again, and click "Split Names" from the list and select "Start";

Step 7: In the new dialog box, select the new columns to add, e.g., "First Name" and "Last Name";

Step 8: Click the "Split" button at the bottom, and first name and last name are now in different columns.

Leave a Reply