Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Including a Cell value into a Chart title with the Text? | Charts and Charting in Excel | |||
How do I select numbers for a formula from a cell including text? | Excel Discussion (Misc queries) | |||
count using multiple criteria including text strings | Excel Worksheet Functions | |||
Dynamic formulas including worksheet references | Excel Worksheet Functions | |||
Multiple formulas including INDIRECT | Excel Worksheet Functions |