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
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram