|I'm sure there's more to this "simple" task than you are telling us. Even in it's "simplest" form as shown above, it's pretty complicated.|
First, there's no way for Excel to calculate anything other than the formula in the cell. If the formula says =B1, Excel is not going to return the value in C1.
You could use =OFFSET(B1,0,1) to return C1, or for your first example above...
If you used Mike's suggestion of a single quote to force the formula to be text...
Then you could use:
Unfortunately, neither of these are going to be dynamic. In both cases you'd need to know what the original formula was and then write a new formula based on that.
There's a slim chance that VBA could be used to break the original formula down into the individual referenced cells, but either the formulas would have to be fairly simple or the VBA would have to be so complicated as to be prohibitive.
In either case, we would need to know a lot more detail about the formulas in question before anything could be written.
I could write some VBA that would work on the specific examples that you gave us, but it would only work for formulas that are summing 3 or 4 cells. Anything other than that and it would fail.
This is one of those cases where trying to keep it simple doesn't work. Perhaps if you told us exactly what you are trying to do, a solution could be found.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.