Jul 30 2021 03:00 PM - edited Jul 30 2021 03:02 PM
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.
Jul 30 2021 03:13 PM
Jul 31 2021 06:00 AM
As variant
=LET(
str, J9,
right, LEFT(str,FIND(")",str)-1),
IFERROR(--RIGHT(right,LEN(right) - FIND("(", right)), 0)
)