You would need VBA for that or xl4, for a VBA solution see

http://www.mvps.org/dmcritchie/excel...htm#getformula


that will give you a string and then you could get the cell address using
MID or RIGHT


The only way one of Excel's regular functions will give you the cell is if
it is used like

=ADDRESS(ROW(Bef22022007!F293),COLUMN(Bef22022007! F293))

however if you put

=Bef22022007!F293

in A10 and wants the cell address then you would need the above VBA or one
of the GET functions from Excel4





"Hilton" wrote in message
...
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