Split names in Google Sheets

Extract name parts from a cell into different columns

The tool makes it easier to divide full names you have in one column into multiple columns with regard to table headers. It recognizes first, last, and middle names along with over 80 suffixes and postfixes. You can tick off the name parts you need and get them in separate columns in a click.

Try it for 30 days for free
Split Names for Google Sheets

With Split Names you will

  • Pull out first, middle, and last names Split cells with full names into multiple columns.
  • Get titles and post-nominals in separate columns The add-on recognizes over 80 titles, suffixes, and postfixes.

How to separate names in Google Sheets

   
Find Split Names in the Split group of Power Tools
Find Split Names in the Split group of Power Tools
Choose all name parts you'd like to get
Choose all name parts you'd like to get
Get the full names divided into corresponding columns
Get the full names divided into corresponding columns
Find Split Names in the Split group of Power Tools
Choose all name parts you'd like to get
Get the full names divided into corresponding columns

License benefits

Our customers get

Unconditional 30-day money-back guarantee
Secure payment
guarantee
Volume discounts: the more you buy, the less you pay
Free support

These companies choose Ablebits products

   

Frequently asked questions

About Split Names for Google Sheets

  • What is Split Names and what do I need it for?

    You've already guessed it from the tool's name, haven't you? :) The add-on pulls the name parts from a cell into different columns. It's smart enough to recognize first, middle, last names, salutations, titles, name suffixes, and post-nominal letters. The results will be placed in separate columns called after the name parts they contain.

  • Doesn't Google provide a free way to split names?

    Well, Google has a useful option - Split text to columns. However, it can split cells by delimiters only, one at a time. If some names are written like "Dumbledore, Albus Percival", you'll have to split them a few times - first by comma, then by space. Besides, Google won't tell a last name from a salutation. It will simply cut the units at the order of their appearance.

    For our add-on, the name parts can be mixed. Your table can have suffixes or titles put before or after the names, and the parts can be divided by any combination of chars. The tool will still recognize any common name unit due to a thought-through algorithm of name recognition.

  • How do I separate names in Google Sheets?
    1. Run Split Names from the corresponding group in Power Tools.
    2. If the column with names has headers, check the corresponding box.
    3. Choose the name parts you need.
    4. Click Split.

    See a more detailed description here.

  • Can I extract last names only?

    Yes, you can extract any part(s) from a full name. Just tick off the necessary options and you'll get the part you need in a separate column next to the full name.

  • What if I have titles along with full names?

    No worries, our add-on recognizes titles and over 80 suffixes and postfixes.

Choose your plan

12-months

  • 12-month access with all updates
$15.00
Buy now

Lifetime

  • Get all new features and updates for free ever!
$39.95
Buy now

System requirements

Operating Systems

  • Microsoft: Windows 7 and up
  • Mac: Yosemite 10.10 and up
  • Chrome OS™

Browsers

  • Chrome™
  • Firefox
  • Safari (Mac only)

Any questions or comments?

Please contact us here

Our working hours:
12:00 am - 10:00 am PST; 3:00 am - 1:00 pm EST; 8:00 am - 6:00 pm CET.

Your message was successfully sent.

Thank you for contacting us!
We will get back to you shortly.

You will receive a delivery confirmation for your message within a few minutes. If you don't get it, please re-send your message and make sure you entered a valid e-mail address.

Close