• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Separate First and Last Name in Excel

April 26, 2021 by Andrew Childress
How to separate first and last names Excel

Imagine a column of first and last names that you want to separate into two columns. Here's how to separate first and last names in Excel.

Imagine a spreadsheet column containing a list of first and last names. To better filter this data, you might prefer to have the first and last names in two columns. Don’t worry – there’s an easy way to do this. Let’s learn how to separate first and last names in Microsoft Excel.

How to Separate First and Last Names in Excel

When you’re working with a column of first and last names, you can use Excel’s Text to Columns feature to separate the two. It’s quick to use, and you won’t have to retype anything.

To get started, select the cells in the column that you want to split. In this example, that’s cells B1:B5. Then, find the Data tab on Excel’s ribbon. Near the right, you’ll see the Text to Columns button.

Separate first and last names Excel

Go ahead and click on it. You’ll see a popup menu appear. Excel recognizes your data as delimited, which means it has a divider like a space, tab, or comma. Ensure the Delimited bubble is selected, then click Next.

Separate first and last names in Excel

Excel now asks you to identify the delimiter. In this case, it’s a space, so click on the Space checkbox. In the box below, you’ll see your data previewed. First and last names now have a line between them.

How to separate first and last names Excel

Click Next again, and then click Finish in the lower right corner. Watch as Excel instantly splits first and last names. The first names remain in the original column, while last names appear in column C just to the right. Now, it’s easier to filter by first and last names, alphabetically, and more.

Separate names in Excel

Thanks to Excel’s Text to Columns option, it’s easy to split first and last names into multiple cells. This makes data analysis a breeze, and saves you time by eliminating the need to retype a single character.

Category: Excel TutorialsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Check mark in ExcelCheck Mark in Excel
Next Post:Combine First and Last Names in ExcelCombine names Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top