Display contents of cell in another cell as part of text string? mschmidt[ at ]carolina.rr.com 08.07.2006 18:32:21 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

Re: Display contents of cell in another cell as part of text string? "RagDyeR" <ragdyer[ at ]cutoutmsn.com> 08.07.2006 18:36:53 Try this: ="The answer is "&B4 Note <space> after "is". -- HTH, RD ===================================================== Please keep all correspondence within the Group, so all may benefit! ===================================================== <mschmidt[ at ]carolina.rr.com> wrote in message news:1152383541.185407.241490[ at ]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

Re: Display contents of cell in another cell as part of text string? SteveW <sj_walton[ at ]nothotmail.com> 08.07.2006 18:38:28 On Sat, 08 Jul 2006 19:32:21 +0100, <mschmidt[ at ]carolina.rr.com> wrote: [Quoted Text] > 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)

Re: Display contents of cell in another cell as part of text string? daddylonglegs <daddylonglegs.2an3sz_1152384303.8782[ at ]excelforum-nospam.com> 08.07.2006 18:44:27 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?action=getinfo&userid=30486 View this thread: http://www.excelforum.com/showthread.php?threadid=559641