Separating specific numbers from a long sting of text

Hi,

I am trying to format a long list of cells that contain items like this:

A1= SOME COMPANY NAME HERE (Acct 1469799391APX120)
A2= SOME COMPANY NAME HERE (Acct 1469723947IDS091)
A3= SOME COMPANY NAME HERE (Acct 14697193RFD093)

I need to capture the number BETWEEN "Acct" and the next set of words "APX/IDS/RFD" so that it returns something like this:

A1= 1469799391
A2= 1469723947
A3= 14697193

I have been messing around with =LEFT/=RIGHT/=MID/=LEN/etc. and I cannot figure this out for the life of me. If anyone could lend me a hand, I would be very appreciative!

Thanks!

Formula:

=MID(A1,SEARCH("(",A1)+6,LEN(A1)-6-(SEARCH("(",A1)+6))

OK... this formula makes two important assumptions:
1. Each cell always has the string "...(ACCT ######...", and
2. There are always 3 letters, followed by 3 numbers and a closing parentheses at the end

If that is not the case, then it is going to take a bit more work to figure out.

- Vince