Separate names in Google Sheets

This one-step add-on will divide the selected full names in your sheet into different columns with the name parts you choose to see.

How to use the Split Names add-on

Start Split Names

Select the column with multipart names you want to split and open the tool in Add-ons > Split Names > Start:
Run the add-on from the Google Sheets menu.

Note. If you select more than one column, only the names from the leftmost one will be processed.
Tip. You can change the range to split any time before you click the Split button - simply highlight the necessary column or cells in your spreadsheet.
Tip. You can also find Split Names in the Split group in the Power Tools add-on:

  1. Access the Split group from the corresponding Google Sheets menu:
    The Split group in Power Tools.
  2. Expand the Split names group on the Power Tools sidebar:
    The Split Names group in Power Tools.

How to separate names in Google Sheets

You will see the add-on's window with a couple of settings:
How would you like to separate names?

  1. If your column with names has a header row, tick off this checkbox. This option perceives the top value in your column as a header, and therefore will not split it. It will also add headers with the corresponding name parts to the created columns.
  2. Check the boxes next to the name units you want to have in the new columns: First name, Middle name, Last name, Salutation / title, and/or Name suffix / post-nominals.
Tip. Those name parts that you choose not to add will be ignored even if they are present in your original column.

Once you have the range and columns set, click on the Split button to get the selected name parts in a new column to the right of the original one:
Split names from one column to multiple columns.

Responses

payet pierre says:
December 1, 2018 at 12:56 pm

payet pierre dominique
12 rue de la gironde
97418 a la plaine des cafres

Reply
Natalia Sharashova (Ablebits.com Team) says:
December 3, 2018 at 9:14 am

Hello, Payet,

Thank you for contacting us.

I'm sorry but your task is not entirely clear.
For us to be able to help you better, please share a small sample spreadsheet with us (gapps.ablebits@gmail.com) with your source data and the result you expect to get. I kindly ask you to shorten the table to 10-20 rows.
Please don't worry if you have confidential information there, we never disclose the data we get from our customers and delete it as soon as the problem is resolved. Or you can replace any important information with some irrelevant data, just keep the format.

We'll look into your task and see if our software can help.

Reply
Steven Powers says:
January 17, 2019 at 3:36 pm

I am getting a message to purchase but I already renewed my license on Jan 10.

Reply
Natalia Sharashova (Ablebits.com Team) says:
January 18, 2019 at 7:27 am

Thank you for contacting us, Steven.

I will reply to you in the email to avoid posting your license information publicly.
Thank you for your understanding.

Reply

Ask a question (posted publicly)

If you have any questions or issues with this add-in, please feel free to post your concerns in the comments area. As soon as we answer, a notification message will be sent to your e-mail. If you do not want to share your thoughts in public, please contact us at support@ablebits.com.

Copyright © 2002 - 2019 Ablebits.com. All rights reserved.

Privacy policy Terms of use Contact us

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.