Extracting a number before a word or phrase between parentheses

Copper Contributor

I am giving you 2 examples of the data that I need to extract info from.

 

example 1:

FINISH SIZE AFTER EB: 12.909" X 21.750". (3) PART NEST, CREATES (3) 700644-09. FINISH SIZE: 3.803" X 21.750".

example 2:

FULL SHEET (2) PART NEST: CREATES (1) 700644-02 & (1) 700644-0

 

I need to extract the first 3 that is between parentheses in example 1 and the 2 that is between parentheses in example 2.

As you can see the number will fall before the word/phrase "PART NEST".

 

Thanks in advanced for any help that you can offer.

2 Replies
GOT IT.
=IFERROR(MID(J9,FIND("(",J9)+1,FIND(")",J9)-FIND("(",J9)-1),0)
LETS SEE IF IT FAILS IN DIFFERENT CRITERIA.

@Noah_S 

As variant

=LET(
  str, J9,
  right, LEFT(str,FIND(")",str)-1),
  IFERROR(--RIGHT(right,LEN(right) - FIND("(", right)), 0)
)