How to Combine Microsoft Excel Data From Two Cells Into One

Quick summary

To combine data from two cells in Microsoft Excel, you use the ampersand (&) operator to join cell references in a single formula. This method lets you merge cell content quickly without losing the original data in either source cell.

Steps

1. Open your Microsoft Excel worksheet and select the destination cell where you want the combined data to appear, then type an equals (=) sign.
2. Type the cell reference of the first data source, then add an ampersand (&) sign directly after it.
3. Type the cell reference of the second data source immediately after the ampersand.
4. Click anywhere else in the worksheet to run and apply the formula.
5. The combined data from both selected cells will now appear together in the destination cell.