How to Merge Two Columns in Excel 2007

Written by emmanuelle douglas
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Merge Two Columns in Excel 2007
Merge two columns together by using the concatenate function. (perspective grid image by Nicemonkey from Fotolia.com)

Merging data in Excel is an example of some of the powerful features Excel offers. Merging or concatenating can be done using a function or formula. The concatenate function is a built Excel text function and is available from the Formulas tab in Excel 2007.

Skill level:
Moderate

Other People Are Reading

Instructions

  1. 1

    Open Excel and search for a spreadsheet that contains two columns you want to merge. Select "Open" on the Quick Access Toolbar and search for the spreadsheet on your computer. Locate the spreadsheet and click "Open."

  2. 2

    Insert a blank column beside the columns you want to merge. Select the column beside the columns you want to merge and click on the column header. For example, if you want to combine Column A and B, click on the column header C. Once the column header is selected, the entire column is highlighted. Right click on the column header, and select "Insert."

  3. 3

    Use the concatenate function in the first cell of the new column. Click on the cell that will display the first set of merged data. Click on the "Formulas" tab on the ribbon and select "Text." Select "Concatenate" from the list of available functions. The Function Arguments window opens.

  4. 4

    Click in the "Text1" box and select the first cell in the first column that you want merged. The cell data will appear in the "Text1" field. Click in the "Text2" box and select the first cell in the first column that you want merged. The cell data will appear in the "Text2" field. Click "OK." The data is now merged.

  5. 5

    Copy this formula from the first cell to the remaining cells that you want merged. Copy the first formula by right clicking on the cell and selecting "Copy." Highlight the remaining cells in the newly copied column and select "Paste." Your data is now merged.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.