Split names in Google Sheets
Split names in Google Sheets
Extract name parts from a cell into different columns
The tool makes it easier to divide full names you have in one column into multiple columns with regard to table headers. It recognizes first, last, and middle names along with over 80 suffixes and postfixes. You can tick off the name parts you need and get them in separate columns in a click.
Buy license
Choose your plan
- 12-month access with all updates $12
- Lifetime - Get all new features and updates for free ever! $39.95
Download
With Split Names you will
Separate first and last names in Google Sheets Pull out middle names as well as first and last names to their own columns.
Get titles and post-nominals in different columns The add-on recognizes over 80 titles, suffixes, and postfixes.
How to separate names in Google Sheets
If you use Power Tools, you will find Split Names in the Split group.
Choose all name parts you’d like to get
See how many names have been split in the resulting message.
Split full names in Google Sheets into multiple columns.
License benefits
Our customers get
- Unconditional
- 30-day money-back guarantee
- Free support
- Volume discounts: the more you buy, the less you pay
Also read:
- Title: Split names in Google Sheets
- Author: Ian
- Created at : 2024-10-15 21:54:14
- Updated at : 2024-10-17 11:31:26
- Link: https://tools.techidaily.com/ablebits/google-sheets-add-ons-split-names/
- License: This work is licensed under CC BY-NC-SA 4.0.