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?