Data Extraction and Sort from a single column

Here is as far as I have gotten so far. Please tell us the correct values for the cells that are displaying errors or incorrectly displaying blanks.
For strength: =MID(A2,AGGREGATE(15,6,SEARCH({1,2,3,4,5,6,7,8,9},A2),1),SEARCH("|",SUBSTITUTE(A2," ","|",2))-AGGREGATE(15,6,SEARCH({1,2,3,4,5,6,7,8,9},A2),1))
For unit: =INDEX(R$2:R$5,AGGREGATE(15,6,(ROW(R$2:R$5)-ROW(R$1))/ISNUMBER(FIND(R$2:R$5,A2)),1))
For package**: =IF(FIND(S$2:S$3,A2)=SEARCH("/",A2)+1,1,MID(A2,SEARCH("/",A2)+1,FIND(S$2:S$3,A2)-SEARCH("/",A2)-1))
For measure: =INDEX(S$2:S$3,AGGREGATE(15,6,(ROW(S$2:S$3)-ROW(S$1))/ISNUMBER(FIND(S$2:S$3,A2)),1))
**denotes an array formulas which is not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).

Try this as an alternative (four separate array formulae that each need CTRL-SHIFT-ENTER) using FILTERXML:

=FILTERXML("<A><B>"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"/"," "),"ML "," ML "),"-"," ")," ","</B><B>")&"</B></A>","//B[number()=.][1]")

Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.