Cell including text and multiple formulas?

[Shaggyjh]

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

 

[Gary''s Student]

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

 

[Mike H]

Hi,

Like this

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

Wher A1, A2 & A3 contain some value

Mike

 

[Shaggyjh]

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

Thanks a lot

 

[Dave Peterson]

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, ...