Excel 2013 makes it possible for you to automatically generate and combine data that you have already entered into your spreadsheet. One way that you can do this is the CONCATENATE formula, which allows you to combine three columns into one in Excel.
This is a powerful Excel tool to know, as it can help to eliminate a lot of wasted time. Once you have familiarized yourself with the formula and can use it to combine multiple cells into one, you can really expedite and eliminate a lot of tedious data entry that might have been taking up a lot of your time.
How to Merge Three Columns Into One in Excel
The steps below were performed in Excel 2013, but will also work for other versions of Excel. Note that we will show you how to do the basic formula that combines data from multiple cells, then we will show you how to modify it to include things like spaces and commas. This specific example will combine a city, state, and zip code into one cell.
Step 1: Open your spreadsheet in Excel 2013.
Step 2: Click inside the cell where you want to display the combined data.
Step 3: Type =CONCATENATE(AA, BB, CC) but replace the AA with the cell location from the first column, BB with the cell location from the second column, and CC with the cell location from the third column. Press enter to complete the formula.
At this point your data might just be one long string of text, which isn’t useful in certain situations. We can fix this by including some additional parts in the CONCATENATE formula. I am going to modify the formula for the data above so that I get a result that looks like Phoenix, AZ 85001 instead of PhoenixAZ85001.
Step 4: Modify the formula with any required spaces or punctuation. Our formula in this tutorial will now be =CONCATENATE(A2, “, “, B2, ” “, C2). Note that there is a space after the comma in the first set of quotation marks, and a space between the second set of quotation marks.
Step 5: Apply this formula to the rest of the cells in this column by clicking the handle at the bottom-right corner of the cell, then dragging it down to select the rest of the cells.
- The cells do not have to be in this order. You could modify the formula to be =CONCATENATE(CC, AA, BB) or any other variation.
- Updating the data in one of the original, uncombined cells will cause that data to update automatically in the combined cell.
Learn about using the VLOOKUP formula in Excel for a some helpful ways to search for data and include it in cells more efficiently.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.