Excel should allow formulas embedded in text.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

="That would take " & SQRT(A1 * 2) & " days,"
 
Use:
=SUBSTITUTE("That would nnn take days","nnn",B1)
where B1 is the cell with the number of days.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Weighted randbetween text list 3
How to implement subtraction from a range 1
Ranking without skipping ranks and percentile 3
Scrabble Value calculation for Welsh words 0
create a macro that opens, edits then closes cell 1
How to convert decimal year to date format in excel 2
copy rows with values - not formulas 1
expanding SUMPRODUCT 1

Back
Top