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

  • Separate first and last names in Google Sheets Pull out middle names as well as first and last names to their own columns.
  • Get titles and post-nominals in different columns The add-on recognizes over 80 titles, suffixes, and postfixes.

How to separate names in Google Sheets

If you use Power Tools, you will find <i>Split Names</i> in the <i>Split</i> group.
If you use Power Tools, you will find Split Names in the Split group.
Choose all name parts you'd like to get
Choose all name parts you'd like to get
See how many names have been split in the resulting message.
See how many names have been split in the resulting message.
Split full names in Google Sheets into multiple columns.
Split full names in Google Sheets into multiple columns.

License benefits

Our customers get

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

These companies choose Ablebits products

Frequently asked questions

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

This add-on takes the name parts from a cell into different columns. It’s smart enough to separate first and last name in Google Sheets and recognize middle names, salutations, titles, name suffixes, and post-nominal letters. The results will be placed to different columns called after the name parts they contain.

Isn't there a formula or another free way to separate names in Google Sheets?

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.

Our Split Names add-on knows how to deal with the mixed name parts. Your table can have suffixes or titles put before or after names with any combination of chars in-between. The tool will still recognize any common name units due to a thought-through algorithm of name recognition.

How do I separate names in Google Sheets?

  1. Run Split Names from the Extensions menu or from the Split 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 split any part(s) from a full name in Google Sheets. Just tick off the necessary units and you’ll get the part you need in a new column next to the full name.

What if I have titles or suffixes along with the full names?

No worries, Split Names recognizes titles and over 80 suffixes and postfixes.

Choose your plan

12-month

  • 12-month access with all updates
$15.00
$12.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: High Sierra 10.13 and up
  • Chrome OS™

Browsers

  • Chrome™
  • Firefox
  • Safari (Mac only)