If you have a spreadsheet that lists customers or employee names, then there is a strong possibility that the first and last names are saved in different columns. This provides a lot of versatility, but it can be a bit of hassle if you would like to use that information for another purpose that requires the names to be combined.
But if you want to avoid copying and pasting, or manually retyping, all of that information to have the first and last names combined in one location, then excel has a solution that might be helpful. Our guide below will show you a formula that you can use to quickly combine data from two separate cells into one new cell.
Combine Two Cells Into One With Excel 2013
This tutorial is going to take a single cell with a first name and a single cell with a last name, then combine them into one cell. We will also be adding a space between the two names. This method will show you how to use the CONCATENATE formula to combine data from different cells, plus it will show you how to add characters that do not appear in a cell.
Step 1: Open your worksheet that contains the cell data you wish to combine.
Step 2: Click inside the cell where you would like to display the combined first and last names.
Step 3: Type =CONCATENATE(A2, ” “, B2) into this cell, then press the Enter key on your keyboard. You can replace the A2 in the formula with the cell location of the first name, and you can replace the B2 with the cell location of the last name.
If you wish to customize the display more, then the formula is broken down into pieces below:
A2 – The piece of information that you wish to display first.
” ” – The characters that you wish to display between the two cell values. This example is a blank space, but it could be changed to “-” if you wanted to show a dash instead.
B2 – The piece of information that you wish to display last.
If you have entire columns containing data that you would like to combine in this way, then you can simply copy the cell containing the CONCATENATE formula, then paste it down into the rest of the cells in the column.