MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Formula within text


Posted by Tony Chard on December 13, 2001 5:41 AM

I'm trying to insert a formula in to a text statement, which contains parentheses. For example

TEXT EXAMPLE ('A2' to 'A3') MORE TEXT

Thanks.


Posted by Jacob on December 13, 2001 6:49 AM

Try this

="Text"&(formula)&"Text"

for example

="The Total Is "&A5+B5&" Dollars"

Jacob