The Split Names tool divides first, last, and middle names as well as salutations and titles from one cell into individual cells.
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.
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:
You will see the Split Names pane with the tool’s options:
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!