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.
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."
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."
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.
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.
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.