Text/Number String Formula Help

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! :-)

Try this:

Formula:

Please Login or Register  to view this content.

Perhaps

=LOOKUP(100,--RIGHT(A1,{1,2}))

another way

Formula:

Please Login or Register  to view this content.

and Control+Shift+Enter

Another way (CSE):

Formula:

Please Login or Register  to view this content.

You guys ROCK...
thanks so much.
All of them work. I will determine which works best with data set.
Thanks so much for solving what I have been trying to solve myself for past hour or so...

TEXTJOIN()
This function is available if you are an Office 365 subscriber and have the latest version of Office installed. It's also available with Excel Online, Excel Mobile, Excel for iOS, and Excel for Android phones and tablets.

Thank YOU!

If the basic problem is solved
- it's always a good practice to show respect to the person(s) who have helped you
- is a click on the Add Reputation first (left lower corner of the post of person(s) who helped you) and then
- mark the thread as SOLVED (top right corner over your first post - Thread Tools). This is important for all of us,
Thanks

Thanks Zbor

Deserved