Can you have a formula and text in an excel cell
Ads by Google
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
- 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.
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?
Ads by Google