Extract Numbers and specific text from column

Hey guys I'm having trouble trying to figure out how to separate some numbers, and text from other text.

Here's some examples of what I'm working on:


The book of blah blah blah (2013) (59093211)
Spiderman (2015) is the greatest (TBD)
Example example random blah blah (1414210)
Chronicles of Anchorman (TBD)

ect...

I have thousands of lines like this in a single column. I need to extract both the "(59093211)" and "(TBD)" from the text at the end and place them in column 2. The numbers I need to extract are always the same length in characters (8).

Any ideas how I can do this?

Give this a try. I missed the 2 values of (Blahblah) and (blah) in the same cell. Formula will not work correctly

Please Login or Register  to view this content.

Formula will not work, that was posted

Give this a try

Formula:

Please Login or Register  to view this content.