Convert Cell References in Formula to Values
 

Help Please!!!

I need to convert a huge number of cells containing formulas that of course
have references to formulas consisting only of values. In other words, I
need to convert all cell references to their corresponding values.

Example
Cell D50 contains a formulaeg: =1000+b2/2+1200-sum(a1:a40)
I need D50´s formula to become: =1000+50/2+1200-15

Pleas help me!
Thanks in advance,
Humberto