How to separate names in Excel
The Split Names tool divides first, last, and middle names as well as salutations and titles from one cell into individual cells.
Before you start
The add-in doesn't process merged cells. If the selected range contains merged cells, the tool will notify you. We recommend either unmerging the cells beforehand or selecting a column without merged cells after starting the add-in.
How to split names into new columns
Start the Split Names tool
Run the tool by clicking the Split Names icon in the Text group on the Ablebits Data tab:
Or find the Split Names icon in the Transform group on the Ablebits Tools tab:
Separate names into columns
You will see the Split Names pane with the tool’s options:
- Click the Expand selection icon and have the entire column selected automatically.
- Use the Select Range icon to change the selected column to another one:
- If there's a header in the selected column, select the My table has 1 header row checkbox.
Tip. If there are more header rows in your table, click 1 header row, enter the number of header rows, and they won't be pulled apart:
- Select the checkboxes with all the name parts you would like to see in new columns. The add-in recognizes over 80 kinds of Salutations / titles, First names, Middle names, Last name prefixes, Last names, Initials, and/or over 30 kinds of Name suffixes / post-nominal letters.
Click Split and get the columns with the selected name units inserted to the right of your original column.
Post a comment
Seen by everyone, do not publish license keys and sensitive personal info!
If you have any questions or issues with this add-in, please feel free to post your concerns in the comments area. As soon as we answer, a notification message will be sent to your e-mail. If you do not want to share your thoughts in public, please contact us at support@ablebits.com.
