Formula's in text

[Brad]

I have a gift certificate template in excel. I have a cell that has a string of text that says "to redeem $xx off your next purchase" I would like to have the dollar amount reflect a cell inside the workbook so that I only have to change one cell and it changes the value in that string of text as well. Is it possible to have a formula inside a string of text?

 

[millsy]

*I have a gift certificate template in excel. I have a cell that ha
a string of text that says "to redeem $xx off your next purchase"
would like to have the dollar amount reflect a cell inside th
workbook so that I only have to change one cell and it
changes the value in that string of text as well. Is it possible t
have a formula inside a string of text? *

Say you had the dollar amount in cell A2. Your formula would be:

=concatenate("to redeem ",text(a2,"$000.00")," off your nex
purchase.")

Make sure you put a space at the end of "to redeem " and at th
beginning of " off your next purchase.".

You can change the number format by changing the "$000.00" part