Extract value from string following word from defined list - multiple times within one cell

[GK007]

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!

 

[hiker95]

GK007,

If you are able to edit/add to the title, per the above, then, after you do that, start a new reply by trying the following:

Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you, with Mac experience.