Cell including text and multiple formulas?
Just to add...
If you need the values formatted nicely...
="there were " & a1 & " dogs walking on " & text(b1,"mm/dd/yyyy")
& " at " & text(c1,"hh:mm:ss") & "."
Same kind of thing with money, percentages, ...
Shaggyjh wrote:
Hi,
Is it possible to have a sentence in a cell (A1) that picks up values from
several cells elsewhere on the spreadsheet? E.g. A1 reads:
There was x dogs walking with y owners past z lamp posts.
Where x,y and z are values pulled from a seperate sheet within the
spreadsheet.
And the rest of the text is entered in cell A1
Many thanks,
James
--
Dave Peterson
|