Formula to Extract Numbers from Text Cell

Hello,

I was wondering if someone could help me. I need a formula to extract numbers. The problem is that what I need are loan numbers and some numbers within the cell is not part of the loan number. For instance:

DATA (Column A)
B012.T01234TOPSHEET
.1234567890T22222ADM
B1235678901234T22222

RESULT (Column B)
BLANK (No Loan Number to extract)
1234567890
5678901234


Is there a formula than can do this for me?

The amount of data changes every month. Sometimes there is one day of activity and sometimes there are 5 to 10 days worth of activity. I need to do the same formula for multiple spreadsheet and would also like to know if I can create a macro for this as well.


Thank you!
~MHamid