My formula is =Sum(E38). How can I add text to the formula?
Hi Marie,
="The Number of Occurences Reported is "&SUM(E38)
or
="The Number of Occurences Reported is "&E38
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Marie" wrote in message ...
| How can I add text to a formula in a cell. Example: The cell now is
| =Sum(E38). How can I add to the beginning of the formula so that the
| following words appear in the same cell The Number of Occurences Reported is
| --
| Marie
|