ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

Tutorial – MS Excel – How to combine multiple columns into a single column in excel

Updated on October 4, 2016

Combining 2 or more column values in an excel worksheet can be easily done using a simple mathematical formula. The process of combining is also called as "Concatenation".

Formula: Concatenate(Cell1, Cell2,….)


1. Assume these are the values in 2 columns that you want to combine into one column.

2. Corresponding to the first row of values, click on the cell where you want the concatenated value to appear. Start typing the formula “=CON”, a list of formulae will appear. Select the “Concatenate” function by double clicking on it.

3. Select the first cell to be concatenated by single clicking on it. The cell number will automatically appear in the formula.

4. Type comma “,” and click on the second cell to be concatenated. The cell number of the second cell will also automatically appear in the formula. You can continue this process of adding cells to be combined by typing comma & cell number for all columns. Once you are done adding the cell numbers you can close the formula using a closing brace “)”.

5. In this case we just have 2 columns to be combined. Hence we can close the formula using a closing brace and hit “Enter”. The final formula will look like this: “=Concatenate(A2,B2)”

6. Once you hit enter, the concatenated value will appear in the cell where you have typed the formula.

7. If you want to copy the formula, select the cell where the formula was written and hit “Ctrl+C” to copy the formula.

8. Select the cells where the formula is to be pasted.

9. Hit “Ctrl+V” to paste the formula in the selected cells. The result will be a column with the merged values from the 2 columns.


    0 of 8192 characters used
    Post Comment

    • collegedad profile image

      collegedad 4 years ago from The Upper Peninsula

      I'm excel illiterate, but would like to learn more about it. Spreadsheets and graphs are required in a lot of my papers. I have a miserable time putting them together. Would be great to have a series of hubs that explain Excel in detail. Great hub and thanks!

    • nehanatu86 profile image

      nehanatu86 4 years ago from Hyderabad, Andhra Pradesh

      Thank you for your interest collegedad. I am glad my hub was of some use for you.

      Yes, I am currently working on some more hubs on MS Excel. Meanwhile, you may want to go through one of my other hubs on Excel. Here's the link:

    Click to Rate This Article