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

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Combine First and Last Names in Excel

April 26, 2021 by Andrew Childress
Combine names Excel

You might find yourself working with first and last names in separate spreadsheet columns. Here's how to combine first and last names in Excel.

You might find yourself working with first and last names in separate spreadsheet columns. But suppose you want to combine them together. Let’s learn how to combine first and last names in Microsoft Excel.

How to Combine First and Last Names in Excel

Consider two columns of data. Column C contains a list of first names. Column D contains a list of last names. Now, imagine that you want column E to contain both the first and last names. Excel has a quick shortcut for this that helps you avoid having to retype anything. It’s called the CONCAT function.

To get started, click into the first open cell in column E. Here, that’s cell E2. Then, type an = sign. That tells Excel that you’re inputting a formula in the cell you’re working in. Continue by typing CONCAT(. So far, your formula reads:

=CONCAT(

Combine first and last name Excel

Then, click into the cell containing the first name at the top of your list. Here, that’s cell C2. Then, type a comma.

Most likely, you’ll want a space between the first and last names. To insert a space, type in ” “, careful to leave one empty space between the two quotation marks. Then, click on the cell containing the last name, D2, and then complete your formula with ). Your full CONCAT formula reads:

=CONCAT(C2," ",D2)

Combine names Excel

Hit Enter on your keyboard, and Excel will combine the first and last names, with a space in the middle.

Combine last and first name Excel

To combine the rest of your list, hover over the lower right corner of cell E2 until you see a + symbol. Then, click and drag downward, releasing when you reach the bottom. Excel will automatically update your formula, and combine the remaining first and last names together.

How to combine names in Excel

As you can see, it’s easy to combine first and last names in Excel, with no need to retype anything.

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

About Andrew Childress

Previous Post: « How to separate first and last names Excel Separate First and Last Name in Excel
Next Post: Remove Duplicates in Excel Delete duplicates Excel »

Sidebar

Recent Posts

  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel
  • EXACT 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
  • LinkedIn
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2022 · Excelypedia · All Rights Reserved

Back to top