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.

Free download Ultimate Suite for:
2019 365 2016 2013 2010
Download this and 60+ other tools for Excel included in Ablebits Ultimate Suite

14-day fully functional version
Split Names for Excel 2019, 2016 - 2010

With Split Names you will

  • Divide multi-part names Separate first and last names, isolate middle names as well.
  • Pull other words apart from names Choose 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

License benefits

Our customers get

Unconditional 60-days money-back guarantee
Life-time license, no additional
fees ever
Free life-time support
Secure payment guarantee
Volume discounts: the more you buy, the less you pay

These companies choose Ablebits products

Frequently asked questions

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

Microsoft Excel

  • Excel included in ​Microsoft 365 (formerly Office 365)
  • Excel 2019
  • Excel 2016
  • Excel 2013
  • Excel 2010
  • 32-bit and 64-bit
  • Note! Office Insider is not supported


  • Windows 10
  • Windows 8.1
  • Windows 8
  • Windows 7
  • 32-bit and 64-bit
  • Note! Windows insider is not supported
  • Note! Surface Pro X and Windows X are not supported

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.

Your message was successfully sent.

Thank you for contacting us!
We will get back to you shortly.

You will receive a delivery confirmation for your message within a few minutes. If you don't get it, please re-send your message and make sure you entered a valid e-mail address.