Separate first and last name in Excel

Split titles, salutations, and suffixes

If you have a worksheet with differently formatted names in the same column, Split Names for Excel will quickly clean up the mess and put first, last, and middle names into individual columns. It perfectly recognizes various multi-part names, over 80 salutations, about 30 courtesy suffixes, and post-nominal letters.

Learn more
This tool is part of
Ultimate Suite
Split Names for Excel 2016 - 2007

With Split Names you will

  • Divide multi-part namesSeparate first and last names, isolate middle names as well.
  • Pull other words apart from namesChoose to detach salutations, titles, and courtesy suffixes.

How to separate first and last name in Excel

  
Calibrate splitting settings
Calibrate splitting settings
Get an instant result next to the original names
Get an instant result next to the original names
Calibrate splitting settings
Get an instant result next to the original names

License benefits

Our customers get

Unconditional 30-day money-back guarantee
Secure payment
guarantee
Life-time license,
no additional fees ever
Volume discounts: the more you buy, the less you pay
1 license
for 2 computers
Free life-time support
Learn more
  • This tool is part of Ultimate Suite
  • 60+ professional tools. No garbage.
Buy now
  • Buy as part of Ultimate Suite
  • 60+ professional tools. No garbage.

These companies choose Ablebits products

   

Frequently asked questions

About Split Names

  • What is Split Names and what do I need it for?

    The add-in does exactly what its name suggests, i.e. separates names in Excel from one cell into several cells. What's more, it recognizes and splits salutations, titles, name suffixes, and post-nominal letters.

  • Can't I separate names in Excel by using some built-in feature?

    Yes, you can use Excel's Text to Columns option. However, it can hardly be called a fast and intuitive process. You will have to specify every single delimiter used between the names, and carefully select the destination range not to overwrite your original data.

    Split Names doesn't care about the delimiters and empty columns. It separates names and inserts as many new columns as necessary to accommodate the name parts, leaving the original names intact.

  • How to separate names in Excel with the Split Names add-in?

    To split names in Excel, do the following:

    1. Select a column with names and click the Split Names button.
    2. Choose which parts of the names you want to pull apart.
    3. Click Split.

    See a more detailed description here.

  • Will Split Names separate first and last names in Excel from titles and salutations?

    Yes, the 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.

Supported versions

 

Excel

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

Windows

  • Windows 10
  • Windows 8.1
  • Windows 8
  • Windows 7
  • Windows Vista
  • Windows XP
  • 32-bit and 64-bit
Free download
14-day trial version
  • Included in Ultimate Suite for Excel
  • 14-day fully-functional version

Any questions or comments?

Please contact us here

Our working hours:
12:00 am - 10:00 am PST; 3:00 am - 1:00 pm EST; 8:00 am - 6:00 pm CET.
Excel add-ins and Outlook tools - Ablebits.com