View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default 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