How to Merge Cell Data

By Ricky Gee

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 1

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

Step 2

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

Step 3

Click on the first cell that you wish to merge.

Step 4

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

Step 5

Click on the next cell that you wish to merge.

Step 6

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.

Tips & Warnings

  • To add a space in between cell data, type "& " " &" (an ampersand followed by quotes with spaces in between followed by another ampersand) in place of the ampersand in Steps 4 and 6.