I have a bunch of cells that contain formulas with values from all over the
place and
I would like to be able to see the values of each formula quickly.

To simplify, using the example formula =(A1+B2)/C3*D4)
I would like to see =(1+2)/3*4

I know I can sort of do this with the watch window or I can do something
like this -
="(" & A1 &" + "& B2 &") / "& C3 &" * "& D4 - in another cell but neither of
those are what I need. The watch window does not show the whole formula at
once and the 2nd is not easily replicated for many cells.

Thanks for looking,
Dan