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
I think Excel Function is OK:
B1=  LEFT(RIGHT(TRIM(A1),LEN(A1)-31),FIND(" ",RIGHT(TRIM(A1),LEN(A1)-31),1)-1)
C1 = MID(RIGHT(TRIM(A1),LEN(A1)-31-LEN(B1)-1),1,FIND(" ",RIGHT(TRIM(A1),LEN(A1)-31-LEN(B1)-1),1)-1)*1
Note:
Trim(A1) to prevent A1 from extra space between character group.
31 = len("002 000950715 082687862003 UPC ") = const for every strings
Find(" ",....) - 1 : is the position of the first character in the string after cut 31 left characters
and so on
You may define a range name Str1 = RIGHT(TRIM($A1),LEN($A1)-31) when the cell point is in row 1.
And another range name Str2 = RIGHT(TRIM($A1),LEN($A1)-31-LEN($B1)-1) when the cell point is also in row 1.
Then the formulas are:
B1 = left(Str1,find(" ",Str1,1)-1)
C1 = Mid(Str2,1,Find(" ",Str2,1)-1)*1