How to Combine Columns of Data in MS Excel

Combining Values Through Arithmetic
1. Launch Excel on your computer and open the spreadsheet for which you want to combine columns of data through arithmetic.
2. Click on the first row of an empty column and type the following formula into the cell:=$A1 $B1.Replace 'A' with the column holding the first value to be combined and 'B' with the column holding the second value to be combined. Replace the ' ' (sum) operator with whatever Excel operator you need to compute the combination.
3. Press 'Ctrl-C' to copy the formula. Select all entries in the column that you want defined. Excel will display the cells in a darker shade to indicate that they are selected.
4. Press 'Ctrl-V' to paste the formula into all selected cells. Excel will compute the remaining entries of the column. The entries in the corresponding rows of pre-existing columns are combined.
Concatenating Cell Values
5. Launch Excel on your computer and open the spreadsheet for which you want to concatenate columns of data.
6. Click on the first row of an empty column and type the following formula into the cell:=$A1$B1.Replace 'A' with the column holding the first value to be combined and 'B' with the column holding the second value to be combined.
7. Press 'Ctrl-C' to copy the formula. Select all entries in the column that you want defined. Excel will display the cells in a darker shade to indicate that they are selected.
8. Press 'Ctrl-C' to copy the formula. Select all entries in the column that you want defined. Excel will display the cells in a darker shade to indicate that they are selected.