You can combine data from multiple cells into a single cell using the Ampersand symbol. To do this: Enter your formula with the ampersand symbol between the cell references. If you want to add a space between the text from each cell, just add quotation marks with a space enclosed.
For more videos, visit: