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!