Last 2 words strip separate

[makinmomb]

GENTS FORMAL LAED LEATHER SOLE BLACK 40
GENTS FORMAL LAED LEATHER SOLE BLACK 41
GENTS FORMAL LAED LEATHER SOLE BLACK 42
GENTS FORMAL LAED LEATHER SOLE BLACK 43

I have this on a1 downwards

want this on b1 downwards

BLACK
BLACK
BLACK
BLACK

want this on c1 downwards

40
41
42
43

want this on d1 downwards

GENTS FORMAL LAED LEATHER SOLE
GENTS FORMAL LAED LEATHER SOLE
GENTS FORMAL LAED LEATHER SOLE
GENTS FORMAL LAED LEATHER SOLE

[azumi]

B1:
=trim(left(right(" "&substitute(trim(a2)," ",rept(" ",60)),120),60))

c1
=trim(right(substitute(trim(a2)," ",rept(" ",255)),255))

d1
=substitute(a2," "&trim(right(substitute(a2," ",rept(" ",100)),200)),"")

[FDibbins]

Is that format always like that....
word space word space word space word space word space color space 2-digit number?

[makinmomb]

Thank you Azumi , it deals with even colours that are not 5 characters like RED