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 :)
Complete support for:
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.
- 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.
- 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:
- And finally, define the output location, more precisely the top left cell of the destination table, and click Run. Your resulting table can be created in the current worksheet, in a new worksheet or another workbook.
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:
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 :)
Check out the most popular add-ins for Microsoft Excel:
- Remove duplicates from Excel worksheets with Duplicate Remover for Excel
- Merge Excel tables together using Merge Tables Wizard
See how the add-in can help you
You can view the video in the fullscreen mode by clicking
Split Names for Excel screenshots
A few clicks and the name parts are moved into individual columns
Split Names for Excel main dialog
Split Names for Microsoft Excel system requirements:
- 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 2.0 must be installed.
If you need to install the add-in for a group of users, please see Corporate deployment.
- Microsoft Excel 2013 (32- and 64-bit)
- Microsoft Excel 2010 (32- and 64-bit)
- Microsoft Excel 2007
- Microsoft Excel 2003
Split Names version
Current add-in version: 2.0.1
published on: Feb 26, 2013
This add-in comes as part of Ultimate Suite (20+ useful Excel tools)
Try Split Names for Microsoft Excel in the package without any limitations for 30 days.
You can order the add-in separately or buy it in the Suite at the best price.
- ABOUT US