Combine 2 Columns in Excel Using CONCATENATE Function

In Microsoft Excel you can take two columns and combine the values into one column.



In my example video you can see there are two columns, Phone and Type, that contain some info. If you want to combine the into one column you take the following steps.

1. Create a new column somewhere in your spreadsheet
   
2. Put the cursor in the first field of the column you created
   
3. Make sure you are on the HOME tab and click on the pull down arrow next to the AUTO SUM button
   
4. Select MORE FUNCTIONS and search for Concatenate
   
5. With your cursor In the first value field click on the first cell you would like to combine
   
6. Put your cursor in the second value field and type a space (this is so your values have a space in between them when they are combined)
   
7. Put your cursor in the third value field and click on the second cell you would like to combine
   
8. Click OK
   
9. If you would like to have this formula applied to the entire column hover over the bottom right hand corner of the cell with the formula in it so you see a dark black cross and double click.
   
10. You are done unless you would like to remove the old columns but keep the Concatenated values (if you do, continue to steps 11 through 13)
    
11. Select all the fields that have a formula in it and COPY the contents
    
12. Paste special the contents back in to the same location and choose Values. This will replace the formulas with Values.
    
13. Remove the original columns and save your document