Hello,

I need to perform calculations using mutiple cell references on a long
spreadsheet. I am using a CONCATENATE function to generate the text of the
long formula. But, I am not able to get excel to think it a formula and not
as text.

I can always click on the cell, add "=" as the first character and hit
"return", it will show the value. But, if add "=" as part of the concatenate
function, excel doesnt think it to be formula, thus the text with the "=" is
displayed.

Any idea how to address this issue?

Thanks in advance