Extract first character numbers and lengths of cell references within a formula.

[guybrown]

Hi

Is it possible to extract the first character numbers and lengths of cell references within a formula?

If I had a formula such as =A1+B23 could I get something like 2, 2, 5, 3 where 2, 2 indicates that the first cell reference starts at the 2nd character and is 2 characters long and the second cell reference starts at the 5th character and is 3 characters long?

Regards,

Guy

I am trying to go a long way about displaying the formula from within another cell but with the cell references replaced with the cell reference values. (I already have a function to extract the formula as text).

 

[Rick Rothstein]

Is it possible to extract the first character numbers and lengths of cell references within a formula?

If I had a formula such as =A1+B23 could I get something like 2, 2, 5, 3 where 2, 2 indicates that the first cell reference starts at the 2nd character and is 2 characters long and the second cell reference starts at the 5th character and is 3 characters long?

What did you want returned if the formula has absolute references in it? For example...

=A$1+$B$23