Can a cell in excel contain text and have a formula included?

P

pennpro

I want to have a string of text where the formula is included that will pull
information from another cell.
ie: The number of attendees for training was (formula), which dropped from
the last session.
 
P

PCLIVE

Like this:

="The number of attendees for training was " & (formula) & ", which dropped
from
the last session."

HTH,
Paul
 
M

Marcelo

hi

="here you have your message "&a2

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"pennpro" escreveu:
 
D

Dave Peterson

And if you need to format the quantity or date:

="The number... " & text(a1,"#,##0.00") & ", which..." & text(b1,"mm/dd/yyyy")
 
Top