MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Nesting a function in a text string


Posted by Bruce on April 16, 2001 4:26 PM

Does anyone know how to nest a function in text? I want to write out something like the following in a normal cell, and make it work:

"The total for this is (=A5)"

The idea here is, to have a text string with one or more dynamic values inside the string, ie the value in A5. I've heard this is possible but cannot find anything on this anywhere. Maybe I'm just not using the wrong terminology here but its as if no one has ever thought about doing this before!

Any help is appreciated,
Thank You,
Bruce


Posted by Bruce on April 16, 2001 4:28 PM

Sorry I meant to say "Maybe I'm just not using the correct terminology here ..."

Posted by RS on April 16, 2001 4:29 PM

="The total for this is " & A5


Posted by Bruce on April 16, 2001 4:33 PM

Thanks RS - fast answer!

Bruce