I have some ID's that I need to extract the numbers out of and concatenate them. I received help on extracting the first set of numbers and it works perfectly, now I can't seem to figure out how to extract the last set of numbers. The strings are as follows:

NCAN4085DC1
NCAT251DC5
PWMB2023DC11
DFWL123AC23

The formula someone from this forum gave me to extract first set of numbers is: =LOOKUP(10000,--MID(B2,5,{1,2,3,4,5}))
The first set of numbers will not begin with a zero and always have the four letter prefix.
The second set of numbers will be 1 or 2 digits and always be preceded by 'DC' or 'AC'.

What I am wanting is:
40851
2515
202311
12323

Thanks in advance for the expert help that I know is out there! :-)