Help & Support
Send Feedback
Split Names
Split name in a cell into multiple cells and auto-detect its parts
1,399 users
Works with
Install
Overview
If you ever need to split first and last names to different columns, this add-on will become a great assistant. It distincts first, last, middle names and recognizes over 80 titles and 40 post-nominals. It doesn't matter how these parts are arranged - Split Names pulls correct units from any name combinations.

With names like "Dumbledore, Albus Percival, Prof." the standard "Split text to columns" Google feature won’t help much since it pulls out name units one by one by a delimiter. Our tool detects all parts at once and separates names to corresponding cells in a click. 

The benefits of the tool are enjoyable:
  • Splits full names in Google Sheets
  • Tells the difference between first, last and middle names
  • Recognizes over 80 titles and 40 post-nominals (Mr and Mrs, MD, Prince, etc.)

The utility will insert columns with name units next to the original one. You can keep your table structure by considering or ignoring headers.

Run this tool to divide multi-part names into separate columns they belong to: first, middle, and last names, titles and post-nominal letters. Splitting names in Google Sheets is that easy!

What's new?
Version 1.8
Improved:
 - Titles and suffixes detection. In many cases they can be recognized even if their position is uncommon.
 - Added new medical suffixes.

Fixed:
 - Some issues with suffixes.

Version 1.7
Improved: 
 - UX

Fixed:
 - The add-on didn't recognize names in UPPERCASE
 - Processing the whole column
 - Minor bugs

Added:
 - We introduced yearly subscriptions, you can still enjoy a fully-functional trial version of the add-on for 30 days.

If you have any questions about the add-on, please post them here: https://www.ablebits.com/docs/howto-split-names-google-sheets/
We'll be happy to assist!
Please visit the Chrome Web Store if you would like to reply or rate a review for this app.
Reviews
Rachael MacRae
March 24, 2019
Saves so much time - worth it
Submit reply
Cancel
Nancy Emerson
February 1, 2019
Saved me so much time, thanks!!
Submit reply
Cancel
A User of Split Names
January 24, 2019
Awesome tool!!!
Submit reply
Cancel
A User of Split Names
January 9, 2019
Did not work for me
Submit reply
Cancel
Alison Wilmot
April 10, 2018
Well that was EASY!
Submit reply
Cancel
A User of Split Names
March 13, 2018
Great add on. however, you must now pay for it forever.
Submit reply
Cancel
Andrew Huang
February 9, 2018
I spent hours trying to split names using formulas and by hand. Formulas took care of 80% but there are tons of Suffixes, middle names left. THIS ADD-ON cleaned up suffix & middle name, in one single click for FREE. Thank you!!
Submit reply
Cancel
A User of Split Names
January 23, 2018
Tool is now non-functional and stuck behind a paywall. Better off leaning how to write this code on my own and doing it myself.
Submit reply
Cancel
A user of Split Names
January 30, 2018
Hello, Neil, Thank you for your feedback. We were reported about the issue with the add-on, already fixed it, and it's already available for our users. If you continue experiencing any problems, feel free to contact us at support@ablebits.com with a description of your problem. We'll do our best to help.
A User of Split Names
November 26, 2017
How much re-typing have I done in the last 5 years? WOW! What a great help!
Submit reply
Cancel
Joy Kidd
August 12, 2017
Saved me tons of work at the beginning of the school year when I copied/pasted student names from the online gradebook to my own spreadsheet.
Submit reply
Cancel
1-10 of 24
Additional information
Search
Clear search
Close search
Google apps
Main menu