Split Names for Microsoft Excel

Split names into first, last, and middle, separate titles and name suffixes

The Split Names add-in for Microsoft Excel does exactly what its name suggests, i.e. splits names from one cell into several cells, and does the job perfectly :)

  • 3 easy steps
  • Splits to Title, First name, Middle name, Last name, and Name suffix
  • Recognizes multi-part names, over 80 salutations, over 30 suffixes

Free download for:

Split multi-part names into several columns with the Split Names add-in

The Split Names add-in recognizes and splits:

  • All kinds of multi-part names, including double surnames
  • Over 80 salutations and courtesy titles, including all common social, professional, political, military and ecclesiastical titles
  • Over 30 suffixes and post-nominal letters, including the most common generation (Jr., Sr. etc.) and professional (such as MD, PHD, ESQ, etc.) suffixes

If you have spreadsheets where multi-part names are written in one cell while you want to have them in individual cells, it may take you the whole day to split all names manually. Our Split Names for Excel will put them in different columns in a wink.

How to split multi-part names in Excel, 3 easy steps:

Imagine that you have an Excel spreadsheet like column A in the screenshot above. Mind you, that column contains entries with all sorts of names and salutations in various formats as it often happens when data come from different sources or are input by different people. Let's see how the Split Names add-in for Microsoft Excel will clean up the mess.

  1. Select the needed range and click the Split Names icon. You can select just one cell within the column to save time and this smart add-in will catch up the entire column.
  2. Choose the parts into which you want to separate names in Excel. You have the following options: First name, Middle name, Last name, Salutation / Title, and Name suffix / post-nominal letters. You can choose to add just one new column, or all available columns:
  3. And finally click Split. The split results will be inserted to the right of your original column.

That's it! Now different name parts are in separate columns and your resulting table has appropriate headers added automatically. Here's how the final table may look like:

Names split into several Excel columns - First name, Middle name, Last name, Salutation, Suffix.

So, all is easy, intuitive and quick. Long manuals and help files are redundant. Of course Help is available in the add-in, just in case :)

Read more:

Quickly split first and last name into separate Excel cells

Split Names for Excel screenshots

A few clicks and the name parts are moved into individual columns

A few clicks and the name parts are moved into individual columns

Split Names for Excel main dialog

Split Names for Excel main dialog

This add-in comes as part of Ultimate Suite - 60+ professional tools for Microsoft Excel

Download and try Ultimate Suite without any limitations for 14 days.

Free Download
Free 14-day trial version, 13 MB

System requirements:

Microsoft Excel

  • Microsoft Excel 2016 (32- and 64-bit)
  • Desktop Excel included in Office 365
  • Microsoft Excel 2013 (32- and 64-bit)
  • Microsoft Excel 2010 (32- and 64-bit)
  • Microsoft Excel 2007

Operating System

  • Windows 10 (32- and 64-bit)
  • Windows 8 (32- and 64-bit)
  • Windows 7 (32- and 64-bit)
  • Windows Server 2008, 2012, 2016
  • .NET Framework 4.0 must be installed.

If you need to install the add-in for a group of users, or on a Terminal Server (servers farm) please see Corporate deployment

Featured customers

Ablebits.com featured customers
Contact us
  Publish your message on our support forum

Our working hours: 0am to 10am PST; 3am to 1pm EST; 8am to 6pm CET.

Ultimate Suite for Excel Professionals
60+ professional tools for Excel 2016-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Sheila Blanchard
Excel add-ins and Outlook tools - Ablebits.com