Excel Tips and Tricks

Combine text from two or more cells into one cell

• Select the cell where you want to put the combined data.
• Type = and select the first cell you want to combine.
• Type & and use quotation marks with a space enclosed.
• Select the next cell you want to combine and press enter. An example formula might be =A2&" "&B2
• If you want to add anything like text or a symbol eg | put this between the two apostrophes