The Ablebits Split Names add-on for Google Sheets will separate first, middle, and last names, salutations and titles, name suffixes, and post-nominals. Select them all, and click ‘Split’ to see the result. The add-on analyzes all names in your selection; identifies all name parts no matter their position in cells, and splits all units accordingly.
For Example, you want to split a list of full names arranged in no particular order using this tool. Once you install Split Names, it will appear in your ‘Add-ons’ menu. Run it, and you’ll see two types of settings to adjust. The first one takes care of headers. If you select it, the value in the first row will not be split and all-new columns will be named after the name parts they contain. The other setting is used to customize how you want to split those names.
Split Names add-on for Google Sheets Discount Code
Split Names is a one-step tool that separates the first and last names in Google Sheets. Not only does the add-on see all delimiter and split text to columns, but it also recognizes titles and post-nominals; tells the first names from middle and last names; and separates all name units to their designated columns.
- Splits full names in Google Sheets: you can pull out first, middle, and last names or split cells with full names into multiple columns,
- Tells the difference between first, last, and middle names,
- Split Names add-on for Google Sheets recognizes over 80 titles and 40 post-nominals (Mr and Mrs, MD, Prince, etc.)
Pricing Plans & Conclusion
Split Names add-on for Google Sheets from Ablebits has the trial version with 30 days for free. Besides, the Split Names add-on for Google Sheets paid 12-month version starts at $15 and $39.95 for the lifetime version.
Split Names add-on for Google Sheets is a smart tool that can recognize first, middle, last names, salutations, titles, name suffixes, and post-nominal letters. You can use this tool to divide the full names you have in one column into multiple columns with regard to table headers. The results will be placed in separate columns called after the name parts they contain. Let’s try now!
|Language Support||English, Français, German, Italian, Spanish, Swedish, and more…|
|Money Back Guarantee||30-Day|
|Operating System||Windows 7 and up|
Mac: Yosemite 10.10 and up
|Shipping||Instantly receive the latest Full Version download link and license code|
|Support Services||Email, Forums, Tickets|
User’s and Editor’s scores
Split Names add-on for Google Sheets is a useful tool for the option to sort information in a variety of ways. With it, you can take first and last name information in one cell and split it into two cells.