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

[mschmidt@carolina.rr.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

[daddylonglegs]

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

[RagDyeR]

Try this:

="The answer is "&B4

Note <space> after "is".
--

HTH,

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

<mschmidt@carolina.rr.com> wrote in message
news:1152383541.185407.241490@m79g2000cwm.googlegroups.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

[SteveW]

On Sat, 08 Jul 2006 19:32:21 +0100, <mschmidt@carolina.rr.com> 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
>

=3D"The answer is " & B4

-- =

Steve (3)