Name Splitter

An add-in for Microsoft Excel that splits names in one cell into individual columns.

Download a trial version now!
  • Split names in one column into multiple columns
  • Easily handle courtesy titles and suffixes
  • Handles names in first-last or last-first order
  • Handles multiple middle names
  • Separates names from addresses
  • Converts "last name, first name" to "first name last name"
Names in a single column before processing
Before
Names split into individual columns after processing
After

The Name Splitter add-in for Microsoft Excel can quickly and easily split names that are in one cell into individual names in individual cells.

The Name Splitter has over 150 courtesy titles and suffixes (including military titles) that it looks for and puts in the courtesy titles and suffixes columns. And you can create and use your own custom list of titles and suffixes.

Another feature converts a list of names in “Last Name, First Name” order to “First Name Last Name”. If you have company names mixed in with your people's names, the Name Splitter has several options to prevent them from being modified.

In addition to splitting names, the Name Splitter can also separate names from addresses. For example, if a cell contains “George Burdell 1 Techwood Drive”, the Name Splitter can split this into “George Burdell” in one cell and “1 Techwood Drive” in another.

Lastly, if you need to combine the split names, there is a feature that does just that — allowing you to put the name in the order you want, using only the parts you want, for example, going to first name last name only.

Download a trial version now!

Customers who viewed the Name Splitter also viewed