- To add text to a formula in a cell, use the "&" symbol to concatenate the text with the formula.
- Click on the cell where you have the formula =Sum(E38).
- Click on the formula bar at the top of the screen.
- Move the cursor to the beginning of the formula.
- Type the following text: "The Number of Occurrences Reported is -- ".
- Add the "&" symbol after the text.
- Type the original formula after the "&" symbol, like this: .
- Press Enter to save the formula.
The final formula should look like this:
= "The Number of Occurrences Reported is -- "&Sum(E38).
This will display the text
"The Number of Occurrences Reported is -- " followed by the result of the formula in the same cell.