Split names in Microsoft® Excel® 2010 - 2000

 

Split Names for Microsoft® Excel®

Add-in to split first, last, middle names, titles and name suffixes in Excel 2010 - 2000

For Microsoft Excel 2010 32-bit and 64-bit, Excel 2007, Excel 2003.

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

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 :)

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.

Download NowFeature TourSee how it works

Names, salutations, titles, suffixes are split impeccably!

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

The Split Names add-in for Microsoft Excel 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

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 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
    • Name suffix / post-nominal letters
    You can choose to add just one new column, or all available columns:
    Split Names for Excel main dialog
  3. 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:

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 :)

Check out the most popular add-ins for Microsoft Excel:



Split Names for Microsoft Excel is compatible with

  • Operating System: Microsoft Windows 7 (x86, x64), Windows Server 2008, Windows Vista (x86, x64),
    Windows 2003, Windows XP.
    .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 Office Excel 2010 32-bit and 64-bit, Excel 2007, Excel 2003.

Download now and see how it can help you




Microsoft Office Marketplace logo

Order Now


Join us on Facebook

Click Like and get 15% discount on all our products right now!


Excel Add-ins Collection - quick way to increase your effectiveness in Excel

 

Ordering information


You can purchase a license of Split Names for Microsoft Excel online with any major credit cards, bank wire transfer, check, PayPal or order by fax.

You can buy this add-in as part of the AbleBits Add-in Collection for Excel (11 add-ins in 1 package) and save 60% off.

Split Names for Microsoft Excel pricing, per license

Quantity

USD

EUR

GBP

Volume discount

1

19.95

14.95

14.95

2-4

18.95

14.20

14.20

5%

5-9

17.95

13.46

13.46

10%

10-24

15.95

11.96

11.96

20%

25-49

13.97

10.47

10.47

30%

50 & more

Contact us for a special price

Buy Now

Have a question? Feel free to ask

Your Name*

Your e-mail*

Subject

Message*

Please remember that we work from 9am to 6pm GMT this is 5:00am - 2:00pm EST, 2:00am - 11:00am PST and our public holidays may differ from yours.




Links   |   Sitemap   |   About us




Plug-ins for Microsoft Excel and Outlook

Copyright © 2003 - 2012 Add-in Express Ltd. All rights reserved.

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.