Excel should allow formulas embedded in text.
 

Then I could write something like "That would take 26 days,", with the 26
coming from a formula.

Excel should allow formulas embedded in text.
 

You mean something like:

="That would take " & SQRT(A1 * 2) & " days,"

In article ,
"ylime" wrote:

Then I could write something like "That would take 26 days,", with the 26
coming from a formula.

Excel should allow formulas embedded in text.
 

Use:
=SUBSTITUTE("That would nnn take days","nnn",B1)
where B1 is the cell with the number of days.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!