Cell including text and multiple formulas?
 

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

Cell including text and multiple formulas?
 

="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

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

Cell including text and multiple formulas?
 

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

Cell including text and multiple formulas?
 

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