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