I have data in cells that looks like this

This is all in one cell.
001 000950694 082687864236 UPC TTD3 24 EA 8.2200 8/3 197.28
I need a macro that extracts "TTD3" and "24" and puts them in separate cells.

Variations: sometimes instead of TTD3, its WS20, SM6, RTD4, GW13, RT40, or10/6RS.

Quantity can be anywhere from 15 to 468.

Here are a couple more examples

002 000950715 082687862003 UPC WS20 48 EA 3.9900 8/3 191.52
003 000969736 082687112108 UPC SM6 12 EA 6.8800 4/3 82.56

The other data in the cell isnt needed, it can be deleted or left as long as the part number and quantity end up in different cells, so for example A1 would start with "003 000969736 082687112108 UPC SM6 12 EA 6.8800 4/3 82.56" and then B1 would contain "SM6" and C1 would contain "12"

Thank you