="There was " & A3 & " dogs walking with " & A2 & " owners past "&A1&" lamp
posts."

--
Gary''s Student - gsnu200847


"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