Split Names (omjobieogknhhlogiaeofbdpipihaanb): Split name in a cell into multiple cells and auto-detect its parts... Read More > or Download Now >
Split Names for Google Sheets
Tech Specs
- • Type: Google Sheets Add-on
- • Latest Version: 35
- • Price: Freeware
- • Offline: No
- • Developer: www.ablebits.com
User Reviews
- • Rating Average
- 3.79 out of 5
- • Rating Users
- 194
Download Count
- • Total Downloads
- 85
- • Current Version Downloads
- 23
- • Updated: December 17, 2019
Split Names is a free Productivity Add-on for Google Sheets. You could download the latest version crx file or old version crx files and install it.
More About Split Names
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!