Combine text from multiple cells:

To combine text from multiple cells into one cell, use the & (ampersand) operator.
1. Select the cell in which you want the combined data
2. Type an = (equal sign) to start the formula
3. Click on the first cell
4. Type the & operator (shift + 7)
5. Click on the second cell
6. Press Enter to complete the formula