How to Merge Two Columns in Excel
Excel 2007 has functions and formulas to help you maneuver complex combinations within a spreadsheet, worksheet or workbook. Formulas calculate data in cells and begin with the equal sign, while functions perform specific tasks on a specified range of data. The function symbol in Excel 2007 is similar to an algebra symbol in mathematics.
Select the cell in the row, the function will be attached to.
Click the "Formulas" tab in the Office Ribbon.
Click the "Insert Function" in the "Function Library."
Type the word "join" in the "Insert Function" box that appears.
Click the "Go" button in the upper-right corner.
Select "CONCATENATE" in the "Select a Function" box, then click "OK."
Click inside the first level blank and type in the cell location from Step 1.
Click inside the second level blank and type in the cell location from the second column. When done, click "OK."
Tips & Warnings
- Excel will display the results of the joined data.