Is away to insert a "formula" into a text?

[Marc]

I'm working on and have been forever a quote sheet. Many of the values
change based on certain criteria. I have a disclaimer sentence at the
bottom of the page and I would to have it set up that when I change the
criteria in the work sheets it would also change it in the sentence. Does
this make sense?

Marc

 

[bpeltzer]

Use the & (concatenate) operator along with the TEXT funtion. For instance:
="Today is " & text(today()),"Mmmm dd, yyyy"). Inside the text function, you
can calculate and format any formula (such as today()) you like.
--Bruce

 

[Pete_UK]

Yes, you could have a formula like this:

="This price of "&TEXT(B1,"0.00")&" is valid for 10 days only from
"&TEXT(A1,"dd/mm/yyyy")

this picks up a date from A1 and your price from B1 and inserts them
into your disclaimer sentence. You can adapt this to suit your
circumstances.

Hope this helps.

Pete

 

[Marc]

Guys thanks that's exactly what I'm looking for.

Marc

 

[Pete_UK]

Thanks for feeding back.

Pete

 

[davesexcel]

Use the & (concatenate) operator along with the TEXT funtion. For
instance:
="Today is " & text(today()),"Mmmm dd, yyyy"). Inside the text
function,

[/QUOTE]


Could be this?

="Today is " & TEXT(TODAY(),"Mmmm dd, yyyy")