It is very easy to combine Microsoft Excel data from two cells into one. Here’s a quick guide on how to do it:
- Inside your Microsoft Excel worksheet, select the cell where you wish to combine the data and then type an 'Equals' (=) sign.
- After that, type the cell reference of the first data and insert an 'Ampersand' (&) sign next to it.
- Subsequently, type the cell reference of the second data.
- Once done, click anywhere around the worksheet to run and apply the formula.
- After completing these steps, the data from the two selected cells will be combined into one.