Split names from one Excel column into several ones

Split Names for Microsoft Excel 2016, 2013-2003


You have a customer database where all names are written in one column. Separating multipart names with all sorts of salutations and suffixes into individual columns can be a very tricky task if you need it accomplished in minutes.


Split Names for Microsoft Excel automates moving parts of names to separate cells. Save plenty of time using this efficient add-in to get first, last and middle names as well as salutations, titles and post-nominal letters accurately split and placed in different cells.

Split multipart names into separate cells.

Split Names for Excel key features

  • Split multipart names into first, middle and last
  • Separate all types of salutations, post-nominal letters, generation and job title suffixes
  • Select the destination for split entries


You can get this add-in as a part of Ultimate Suite for Excel - 40+ tools destined to cut your time and clicks on the most frequent spreadsheet tasks.

How Split Names works

Split multipart names in Excel into first, middle and last, separate salutations, titles, name suffixes and post-nominals.

Suppose, you have a really large table with customers' names. The trick is that first names, middle names, last names, titles and all those mind-twisting post-nominals are in a single column… With the Split Names add-in for Excel, all you need is 5 easy steps to get all name parts in individual columns. You simply select the range with the names to be split, open the Split Names dialog box, select the name parts, pick the destination cell and click Run.

That's it! The task that hasn't let you work with your spreadsheet effectively for so long is done in a blink.

Split multipart names into first, middle and last

Most often names consist of the first and second. Less often they contain the middle one as well. The Split Names plug-in will accurately place these parts into separate cells to let you perform all necessary tasks with them.

Separate salutations, name suffixes, post-nominals and occupational titles

This add-in recognizes and separates even those names that contain titles, salutations, name suffixes, or post-nominal letters. It will easily identify over 80 social, professional, political, military and ecclesiastical titles. In addition, its splitting engine can process over 30 suffixes and post-nominal letters, including the most common generation (Jr., Sr. etc.) and professional (such as MD, PHD, ESQ, etc.) suffixes.

Select the destination for the split entries

With Split Names for Excel you can select the output location for your data. It is possible to place the resulting table in the same worksheet or pick the top left cell in another spreadsheet. When you click Run you will see the new table with the split names, which will have the headers corresponding to the parts you selected.

If you have ever experienced a feeling that comes after you have been doing something for hours and then suddenly learnt that it can be done in minutes or even seconds, try out Split Names for MS Excel to forget this feeling.

Buy now

Split Names for Microsoft Excel system requirements

Microsoft Excel

  • Microsoft Excel 2016 (32 and 64-bit)
  • 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 Vista (32 and 64-bit)
  • Windows XP (32-bit)
  • Windows Server 2003, 2008, 2012
  • .NET Framework 4.0 must be installed.

Split Names for Excel version

Current add-in version: 3.0.24
published on: Feb 02, 2016

Order Split Names for Excel

Buy now
Contact us