Cell including text and multiple formulas?
Hi,
Like this
="There was " &A1 & " dogs walking with " &A2 &" owners past " & A3 &" lamp
posts."
Wher A1, A2 & A3 contain some value
Mike
"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
|