How to Merge Cell Data

Microsoft Excel is the spreadsheet component of the popular Microsoft Office software suite. When building comprehensive spreadsheets, it may be useful to combine data by merging two or more cells. In Excel, you are able to merge adjacent cells, but the data contained within them does not automatically merge. To merge the cell data, use an ampersand (&) to write a formula that combines the data within two or more cells.

...

Step

Click on a cell to select it. This cell is where the merged data will appear.

Step

Type "=" into the cell to begin the formula.

Step

Click on the first cell that you wish to merge.

Step

Press the "Shift" and "7" keys at the same time to type an ampersand (&).

Step

Click on the next cell that you wish to merge.

Step

Repeat Steps 4 and 5 to combine the data from any additional cells. Press "Enter" when you are finished adding cells to merge their data.