Extracting a number before a word or phrase between parentheses

Question

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.

noah_s · Answer

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

sergeibaklan · Answer

Noah_S&nbsp;
As variant
=LET(
  str, J9,
  right, LEFT(str,FIND(")",str)-1),
  IFERROR(--RIGHT(right,LEN(right) - FIND("(", right)), 0)
)

Forum Discussion