How to Merge Two Columns in Excel

By Contributing Writer

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 1

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

Step 2

Click the "Formulas" tab in the Office Ribbon.

Step 3

Click the "Insert Function" in the "Function Library."

Step 4

Type the word "join" in the "Insert Function" box that appears.

Step 5

Click the "Go" button in the upper-right corner.

Step 6

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

Step 7

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

Step 8

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.