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

Try this:

="The answer is "&B4

Note <space after "is".
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

wrote in message
oups.com...
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

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)

Try

="The answer is "&B4

or, if you want to format B4 in a specific way e.g. with 2 decimal
places something like

="The answer is "&TEXT(B4,"###.00")


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=559641