On Sat, 08 Jul 2006 19:32:21 +0100, wrote:

How can I display the contents of a cell in another as part of a text
string.

Such as... "The answer is "B4""

where B4 is the contents of cell B4?

Thanks


="The answer is " & B4

--
Steve (3)