Display contents of cell in another cell as part of text string?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mschmidt@carolina.rr.com - 08 Jul 2006 19:32 GMT

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

Reply to this Message

RagDyeR - 08 Jul 2006 19:36 GMT

Try this:

="The answer is "&B4

Note <space> after "is".

Signature

HTH,

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

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

Reply to this Message

SteveW - 08 Jul 2006 19:38 GMT

> How can I display the contents of a cell in another as part of a text
> string.
[quoted text clipped - 4 lines]
>
> Thanks

="The answer is " & B4

Signature

Steve (3)

Reply to this Message

daddylonglegs - 08 Jul 2006 19:44 GMT

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")

Signature

daddylonglegs

Reply to this Message