Extracting data from a cell into a text thread

[ericinarcata]

How do you extract data from one cell on a worksheet into a text thread on a separate worksheet, all in the same work book. In example, need to pull the values from sheet2 into the text threads on sheet1. Thanks a million.

[BadlySpelledBuoy]

You can do it like this:

="The start of your text goes here "&Sheet2!B2&" and the end of your text goes here".

Might be quicker to just type that bit in though...

BSB

[ericinarcata]

Just marked a solved before trying to figure out your reply. I don't understand.