right formula

[wilg]

is it possible to return the right text formula from the formula in a cell?

right(j42,1)

in cell j42 there is a formula

=Sheet1!c1/2

I want to know if the formula is /2 or if another value like /4

I cant use the value returned refrencing sheet1 as i want a generic formula that I can use over many sheets that will change the sheet ref, thats why i only want to know if the formula is /2, or /4.

Let me know if I need to clarify further..

[mikerickson]

You can do this with names. Select a cell in row 1 and define

Name: colAFormula
RefersTo: =GET.CELL(6, Sheet1!$A1)

Then the formula =colAFormula in a cell will return a string of the formula in column A of the same row as the cell holding the formula.