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,