Mixing text and cell references
Mixing text and cell references
(OP)
Greetings all,
I have a problem I hope you can help me with. I am trying to write the output page for a design spreadsheet and want to show results of previous choices in a sentence form i.e.
"Pipe of" C3 "mm diameter, of total length " C7 "mm
So far the only ways i can think of doing this is to stage it across several cells (looks untidy) or to make a huge lookup table to combine the information into sentances (excessive work and space).
Does anybody know a different way of combining cell results into a text string?
Thanks
I have a problem I hope you can help me with. I am trying to write the output page for a design spreadsheet and want to show results of previous choices in a sentence form i.e.
"Pipe of" C3 "mm diameter, of total length " C7 "mm
So far the only ways i can think of doing this is to stage it across several cells (looks untidy) or to make a huge lookup table to combine the information into sentances (excessive work and space).
Does anybody know a different way of combining cell results into a text string?
Thanks





RE: Mixing text and cell references
RE: Mixing text and cell references
or, in a cell enter this formula
="Pipe of " & C3 & "mm diameter, of total length " & C7 & "mm"
Change cell refs as required.
----------------------------------
Hope this helps.
----------------------------------
maybe only a drafter
but the best user at this company!