How do you put a formula and text in the same cell?

How do I combine text and formulas in Excel?

Combine text from two or more cells into one cell
  1. Select the cell where you want to put the combined data.
  2. Type = and select the first cell you want to combine.
  3. Type & and use quotation marks with a space enclosed.
  4. Select the next cell you want to combine and press enter. An example formula might be =A2&” “&B2.

Can you add text after a formula in Excel?

To add a certain character or text to a formula result, just concatenate a string with the formula itself. To explain to your users what time that is, you can place some text before and/or after the formula.

How can I combine text and numbers in a cell and keep the number formatting?