That's exactly what i wanted. I tried all sorts with &'s but couldn't get it
to work.

Thanks a lot


"Mike H" wrote:

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