How to Combine Two Text Columns in Excel 2013

There are many ways to store data in Excel spreadsheets, and one common choice is placing each piece of data in a separate column. This allows for a lot of flexibility when you need to make changes to everything in a column, but it can seem daunting when you need to combine the data from two columns into a new column.

Excel 2013 has a formula that allows you to automate this process, and will permit you to quickly complete a task that you might have previously thought would require a lot of typing, or a large amount of copy and paste.

 

Combining Two Text Columns in Excel 2013

The steps in this article will assume that you have two columns that each contain a bit of text, and that you would like to combine that text into one column with out retying it, or doing a lot of copying and pasting.

Here is how to combine two text columns in Excel 2013 –

  1. Open the worksheet in Excel 2013.
  2. Click inside the cell in the empty column where you would like the combined data to appear.
  3. Type =CONCATENATE(XX, YY), where XX is the cell location of the first piece of data, and YY is the cell location of the column with the second piece of data, then press Enter on your keyboard to execute the formula.
  4. Click and drag the fill handle at the bottom-right corner of the cell with the combined data, then drag it down to match the cells containing the original data. Excel will automatically fill in those cells with the data from the corresponding cells.

 

These steps are also shown below with pictures –

Step 1: Open your worksheet in Excel 2013.

 

Step 2: Click inside the cell in the empty column where you would like the first instance of the combined data to appear.

click inside the empty column

 

 

Step 3: Type =CONCATENATE(XX, YY) into the cell, but replace XX with the cell location of the first piece of data, and replace YY with the cell location of the second piece of data. If you would like to include a space between the data from the cells, then modify the formula so that it is =CONCATENATE(XX, ” “, YY). You could alternatively make it =CONCATENATE(XX, “-“, YY) if you wanted to put a dash between the data from the two cells. Press Enter on the keyboard when the formula is complete.

combine two text columns in excel 2013

 

 

Step 4: Click and hold the fill handle at the bottom-right corner of the cell, then drag the handle down until you have selected all of the cells where you would like to apply this same formula. You can then release the mouse button to fill in those cells with the formula that you just entered. Excel will automatically update the formula to use the data from the corresponding cells.

fill the rest of the column with the formula

 

 

If you are looking to learn some more helpful Excel formulas, then check out this article about comparing columns in Excel.

solveyourtech.com newsletter
vintage t rex t-shirt

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