How to Combine First and Last Names Into One Cell in Excel 2013


Last updated: January 17, 2017

Spreadsheets in Excel are often used for storing data about customers and employees, and some of the most commonly used data fields in these situations are for their names. If your information is coming from a database, then it is likely that these names are separated into first and last names. But occasionally you will need to combine the first and last name in Excel, and the prospect of doing that manually is probably something you want to avoid.

Fortunately there is a formula that you can use which will allow you to combine first and last names into one cell in Excel 2013. It is the CONCATENATE formula, and it can be very helpful in eliminating the need for a lot of unnecessary manual data entry.

 

Merge First and Last Name Cells Into One Cell in Excel 2013

The steps below are going to use a formula to combine a cell with a first name and a cell with a last name into one cell. If you delete the original, separated cells, then the data in the combined cell will be deleted as well. If you want to delete the original cells and keep the combined cell, then you will need to use the paste as values option.

 

Step 1: Open your spreadsheet in Excel 2013.

 

Step 2: Click inside the first cell in which you want to display the combined data.

click the cell where you want to display the combined names

 

 

Step 3: Type =CONCATENATE(XX, ” “, YY) into the cell. Replace XX with the cell location of the first name, and replace YY with the cell location of the last name. Note that there is a space between the quotation marks in the middle part of the formula. This will insert a space between the combined first and last names. In the example image below, the formula is =CONCATENATE(A2, ” “, B2).

enter the formula

 

 

Step 4: Press Enter on your keyboard to execute the formula.

press enter to execute the formula

 

 

Step 5: Click on the cell with the formula that you just created, click on the handle at the bottom-right corner of the cell, then drag it down to fill all of the cells for which you want to combine the names. Note that you can also copy the formula then paste it into these cells instead. Excel will automatically update the formula so that it displays the combined cells for that row.

copy and paste the formula into the other cells

 

 

Summary – How to combine first and last name in Excel

  1. Click inside the cell where you want to display the combined names.
  2. Type =CONCATENATE(XX, ” “, YY) into the cell. Replace XX with the cell location of the first name, and replace YY with the cell location of the last name.
  3. Press Enter on your keyboard to complete the formula.
  4. Copy the formula into the rest of the cells in the column, if necessary.

There are a lot of other useful formulas in Excel 2013. Learn more about creating formulas in Excel to see what sorts of options you can employ to make some of your tasks a little easier.

birthday t-shirts for boys
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.