Forum Discussion
Noah_S
Jul 30, 2021Copper Contributor
Extracting a number before a word or phrase between parentheses
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". ...
Noah_S
Jul 30, 2021Copper Contributor
GOT IT.
=IFERROR(MID(J9,FIND("(",J9)+1,FIND(")",J9)-FIND("(",J9)-1),0)
LETS SEE IF IT FAILS IN DIFFERENT CRITERIA.
=IFERROR(MID(J9,FIND("(",J9)+1,FIND(")",J9)-FIND("(",J9)-1),0)
LETS SEE IF IT FAILS IN DIFFERENT CRITERIA.
SergeiBaklan
Jul 31, 2021Diamond Contributor
As variant
=LET(
str, J9,
right, LEFT(str,FIND(")",str)-1),
IFERROR(--RIGHT(right,LEN(right) - FIND("(", right)), 0)
)