I have a formula in sheet 1 cells A1:A10 like '=2+(8/3)-B1', '=2+(8/3)-B2', etc.

Now, in sheet 2 I want to check / validate the 'fixed' part of the formulas on sheet 1, that is '=2+(8/3)-'. I would prefer to replace the cell reference in sheet 1 (B1, B2, etc) with a fixed value like 1. This way I am sure that within a column, all formulas are dragged down properly etc.

Any idea on how to achieve this?! I was thinking of the indirect function, but I am not sure if that may be the best solution...

Thanks for any consideration given!