Excel 2003: Combining Columns
To combine data in two or more columns into another column follow these steps:
- Click on the first merge cell in the merge column. Then type into the formula bar =CONCATENATE(Cell Reference1 ,Cell Reference2). To add a space between the cell references simply add " " between references. All cell references and spaces should be seperated by a comma. For example, =CONCATENATE(A2," ",B2).
- Click and hold the lower right corner of the cell. The mouse pointer should change to a plus sign. Drag the mouse down to the last merge cell in the column.
- Excel's Auto Fill function will automatically put in the correct cell references for the other rows. The process is complete.
