Hi,

I don't think I made it clear - this is formula in a cell, not a label. So
the function must pick up the fomula in the cell and then extract the row
referenced by the formula. The solution provided works when I make the
formula a label.


"Teethless mama" wrote in message
...
=MID(A1,FIND("!",A1)+2,99)+0


"Hilton" wrote:

I would like to extract the row number in a reference formula

formula in cell "= Bef22022007!F293"

How can I extract the 293?

Thanks
Hilton