App Icon
Ablebits
•  2,080,679
Overview
Split name in a cell into multiple cells and auto-detect its parts.
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!

30 DAYS OF FREE USE
Fully functional 30-day trial period. All payments are secure and include an unconditional 30-day money-back guarantee.

If you have any questions about the add-on, please post them here:
https://www.ablebits.com/docs/google-sheets-split-names/
We'll be happy to assist!

Split Names is a proud member of the Ablebits product family. We build add-ons that help you make the most of Google Workspace. Visit our official website to learn more:
https://www.ablebits.com/google-sheets-addons.php
–––––––––––––––––––––––––––––––––––––
WHAT'S NEW:

***** V1.10 (5 May 2021) *****
Fixed:
- If the names to split were located in the AA column or further, the split parts were inserted into A-Z columns.
- Didn't work with small ranges without headers that started from the A1 cell.
- Errored if your 'Data validation' rules prevented the tool from returning the split name units.
- Didn't work if you run the add-on from a sheet with its own separate chart.

***** V1.9 *****
Improved:
- Imperial, royal, noble, gentry and chivalric ranks are now supported and treated as titles.

Fixed:
- Didn't know the difference between roman numerals and the first letters of middle names.

***** V1.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.

***** V1.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.
Reviews
Language:
Sort by:
Profile Picture
Juan Miguel Orfalas
May 9, 2021
love to me,pls.
Is this review helpful?
Yes
No
Profile Picture
Keyaira Rosado 2029
April 19, 2021
because it wouldn't let me on it
Is this review helpful?
Yes
No
Profile Pciture
Ablebits team
April 20, 2021
Hello Keyaira, Sorry to hear you've had difficulties with our add-on. Please contact our support team with a detailed description of the issue you've encountered – we'll do our best to help.
Profile Picture
Lisa Spencer
December 11, 2020
Fantastic tool! Saved me hours of work - correctly split nearly 600 names into Salutation, First, Middle and Last in seconds! Support staff were very fast to answer and the FAQ's are great also. Thanks guys!
Is this review helpful?
Yes
No
Profile Picture
Robert Wolfe
November 9, 2020
Great product! Easy to use and comes in very handy when you need to split names to be able to sort a list! When I had questions, the support staff was very quick to reply and get me the info I needed.
Is this review helpful?
Yes
No
Profile Picture
Kevin Harmsworth
September 21, 2020
I had a problem signing on after payment had been made. The support staff were very helpful making life a little easier at this end to get everything working. I would highly recommend them.
Is this review helpful?
Yes
No
Profile Picture
Rafael Martinez
September 14, 2020
Great product
Is this review helpful?
Yes
No
Profile Picture
Yakin Opat
September 8, 2020
nice
Is this review helpful?
Yes
No
Profile Picture
Flying Pirate
September 1, 2020
does an awesome job and saves me a TON of time!
Is this review helpful?
Yes
No
Profile Picture
A User of Split Names
May 18, 2020
Great!
Is this review helpful?
Yes
No
Profile Picture
Rodney Steele
July 2, 2019
Saves a ton of time, and works perfect.
Is this review helpful?
Yes
No
1-10 of 34
Additional information
Ablebits
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu