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.

Step

Select the cell in the row, the function will be attached to.

Step

Click the “Formulas” tab in the Office Ribbon.

Step

Click the “Insert Function” in the “Function Library.”

Step

Type the word “join” in the “Insert Function” box that appears.

Step

Click the “Go” button in the upper-right corner.

Step

Select “CONCATENATE” in the “Select a Function” box, then click “OK.”

Step

Click inside the first level blank and type in the cell location from Step 1.

Step

Click inside the second level blank and type in the cell location from the second column. When done, click "OK."