Help & Support
Send Feedback
Split Names
Quickly split full names to several columns with first, middle, last names, titles, and/or post-nominal letters.
19 users
Works with
Install
Overview
If you ever need to have first and last names in different columns, this add-on will prove to be a great assistant. You can complete this task in a click: choose the name parts you need and click "Split" to have them pulled out to separate cells. That's it!

The add-on recognizes over 80 titles and 40 post-nominals; you can be sure you address people appropriately. Once you start it you'll see how simple it is to divide the names:
- Select your column with full names
- Start the add-on and pick the parts you have: titles, name parts, and post-nominal letters
- Click "Split" and see new columns with the results
The add-on will insert columns with the selected name units next to the original one.  You can keep your table structure by considering or ignoring headers.

Run this add-on to divide multi-part names into separate columns they belong to: first, middle, and last names, titles and post-nominal letters. Splitting names 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
February 1, 2019
Saved me so much time, thanks!!
Submit reply
Cancel
A Google User
January 24, 2019
Awesome tool!!!
Submit reply
Cancel
January 9, 2019
Did not work for me
Submit reply
Cancel
January 15, 2019
Hello, Kristen, We would appreciate if you could email us to support@ablebits.com with the description of the problem you encountered. We would do our best to make the add-on work for you and it would help us improve. Thank you.
April 10, 2018
Well that was EASY!
Submit reply
Cancel
March 13, 2018
Great add on. however, you must now pay for it forever.
Submit reply
Cancel
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
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
November 26, 2017
How much re-typing have I done in the last 5 years? WOW! What a great help!
Submit reply
Cancel
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
July 19, 2017
It's free, saves you a bunch of time, and does exactly what it says. 5 stars well deserved
Submit reply
Cancel
1-10 of 23
Additional information
Search
Clear search
Close search
Google apps
Main menu