Mixing text and cell references

Jkaen · Apr 8, 2004

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 · Apr 8, 2004

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

onlyadrafter · Apr 8, 2004

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!

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Mixing text and cell references

Jkaen

Chemical

FrankHarper

Industrial

onlyadrafter

Mechanical

Similar threads

Part and Inventory Search

Sponsor