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

Last updated: August 16, 2018

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.

 

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.

We also explain the steps below with pictures, if you would prefer to see the instructions in that format.

 

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

 

Frequently Asked Questions

Question 1 – Will the combined name update if I change the first or last name?

Answer 1 – Yes, the cell containing the full name will update if you make a change to a first or last name in a cell. The full name cell is being populated by a formula, and part of that formula involves checking a specified cell for its current value.

Question 2 – Is there a way that I can update the full name cell so that it won’t change if I make a change in one of the first or last name cells?

Answer 2 – Yes, you can accomplish this by selecting all of the cells containing values that you don’t want to update, pressing Ctrl + C to copy them, then clicking the Paste button in the ribbon and selecting the Paste as Values option.

Question 3 – Can I split a column of full names into First Name and Last Name Cells?

Answer 3 – Yes, you can do this with the Text to Columns option on the Data tab. This assumes that all of the names consist of just two words.

  1. Insert a blank column to the right of the column that contains the full name.
  2. Select the column containing the full name.
  3. Click the Data tab.
  4. Click the Text to Columns option.
  5. Select the Delimited option, then click the Next button.
  6. Select only the Space option from the list of Delimiters, then click the Finish button.

Note that you can end up with more than one extra column of data if any of the names are three words. Excel splits data into separate cells each time it encounters a space. If you have names with more than two words you will need to create an additional empty column for whatever the highest word count is among your full names. You will then need to combine these extra columns back into the appropriate columns for your needs.

Question 4 – Is there another formula that I can use to combine first and last names in Excel besides concatenate?

Answer 4 – Yes, you can also combine first and last names in Excel using the formula below:

=XX&” “&YY

Note that the only space in the formula is between the ampersands. That space is what adds the space between the names in the full name field. be sure to replace the XX part of the formula with the cell containing the first name, and the YY part of the formula with the cell containing the last name.

 

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.

solveyourtech.com newsletter
vintage t rex t-shirt

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