This should be easy i am sure.

I want to get the row address out of a cell reference and into another cell.

EG given cell B2 which contains =sheet!a345 I would like to store 345 in C2.

Is there a formula which allows me to do this?

thanks in advance