Mixing text and cell references

[Jkaen]

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

 

[FrankHarper]

Use the concatenate function. =concatenate("text",c1,"text",c2)

 

[onlyadrafter]

Hello

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!