Hello team,
Would really appreciate your help on this:
Example:
Cell contains the following (letters and figures, no particular size or order):
CODE-97 1340 : VARIETY P8039 BATCH Н-15-097/1465/2626709-931 BAGS; VARIETY P8521: BATCH Н-15-097/2030/2661313-166 BAGS
I need to extract varieties and corresponding number of bags into separate cells:
P8039 931 P8521 166
Another complication is that "VARIETY" can sometimes be "HYBRID" and a few other names, same for "BAGS" (can be "UNITS" and a few other words).
So challenge is creating a formula that will check values from the provided list (VARIETY, HYBRID, ABS, BVC, etc.) and then extract value following it within the cell on MULTIPLE occasions (because we can have several per cell).
Thanks a lot in advance!
Would really appreciate your help on this:
Example:
Cell contains the following (letters and figures, no particular size or order):
CODE-97 1340 : VARIETY P8039 BATCH Н-15-097/1465/2626709-931 BAGS; VARIETY P8521: BATCH Н-15-097/2030/2661313-166 BAGS
I need to extract varieties and corresponding number of bags into separate cells:
P8039 931 P8521 166
Another complication is that "VARIETY" can sometimes be "HYBRID" and a few other names, same for "BAGS" (can be "UNITS" and a few other words).
So challenge is creating a formula that will check values from the provided list (VARIETY, HYBRID, ABS, BVC, etc.) and then extract value following it within the cell on MULTIPLE occasions (because we can have several per cell).
Thanks a lot in advance!