Count spaces in a cell starting from the right and return charters after spaces in text.

I am attempting to make a PDF report converter in excel. When I copy and paste regular reports the data shows up like this in each cell. Rather than using the “Text to Columns” feature, I want to use formulas on sheet two to cut down on the repetitive manual tasks.

When pasted the data looks like this:
Store 0056 Green Red Blue 9 10 4 59 34 20 12/31/2018

I need to extract the numbers 9, 10, 4, 59, 34, and 20 as shown in the example above. The colors can be variable so using a character count formula such as Left() won’t be accurate. I believe it would work if I could count the spaces starting from the right side of the cell and return the string of text until it reach another space. For example if I could tell excel to start from the RIGHT() and count 5 spaces to the left, it would return the number 10.

Any idea how this might work?

I'm not very familiar with the abilities or limitations of power query. Not sure how that would work.

Store 6125 Red Green Blue 6 6 4 4 0 0
Store 0021 Green Blue Orange 5 5 5 5 1 1
Store 0023 Red Yellow 91 67 38 26 52 36
Store 0030 Blue Green 9 7 11 6 1 1
Store 0033 Yellow Red Brown 11 8 10 10 8 5
Store 0034 Black White 25 23 16 12 13 11
Store 0035 Green Blue Orange 57 50 30 22 30 48
Department 0041 Red Green Blue 50 35 19 15 17 9
Department 0044 Green Blue Orange 15 12 7 8 4 3
Department 0045 Red Yellow 37 28 20 18 9 11
Department 0046 Blue Green 52 40 36 24 29 36
Department 0054 Yellow Red Brown 20 13 15 11 0 0
Department 0150 Black White 7 7 2 2 0 0
Department 0263 Green Blue Orange 21 13 18 14 0 0
Department 0303 Red Yellow 36 29 19 14 16 24

So neither of the solutions really worked for my needs, because some of the colors names have numbers in them also. I changed the data for posting. The solution I found that worked I found from another posting online. Here is the formula:

In this example cell C483 was the referenced cell:

IFERROR(TRIM(MID(SUBSTITUTE(C483," ","ᴓ",LEN(C483)-LEN(SUBSTITUTE(C483," ",""))-11),SEARCH("ᴓ",SUBSTITUTE(C483," ","ᴓ",LEN(C483)-LEN(SUBSTITUTE(C483," ",""))-11))+1,LEN(SUBSTITUTE(C483," ","ᴓ",LEN(C483)-LEN(SUBSTITUTE(C483," ",""))-11)))),"")