Split names in Google Sheets

This add-on takes the name parts from a cell into different columns. It’s smart enough to separate first and last name in Google Sheets and recognize middle names, salutations, titles, name suffixes, and post-nominal letters. The results will be placed to different columns called after the name parts they contain.

Well, Google has a useful option — Split text to columns. However, it can split cells by delimiters only, one at a time. If some names are written like "Dumbledore, Albus Percival", you'll have to split them a few times: first by comma, then by space. Besides, Google won't tell a last name from a salutation. It will simply cut the units at the order of their appearance.

Our Split Names add-on knows how to deal with the mixed name parts. Your table can have suffixes or titles put before or after names with any combination of chars in-between. The tool will still recognize any common name units due to a thought-through algorithm of name recognition.

1. Run Split Names from the Extensions menu or from the Split group in Power Tools.
2. If the column with names has headers, check the corresponding box.
3. Choose the name parts you need.
4. Click Split.

See a more detailed description here.

Yes, you can split any part(s) from a full name in Google Sheets. Just tick off the necessary units and you’ll get the part you need in a new column next to the full name.

No worries, Split Names recognizes titles and over 80 suffixes and postfixes.