I need to have the values in these cells "splitted":

A1: Red 8 Y 48
A2: Magenta 2 Y 16
A3: Green 30
A4: Blue 12

to something like these:

B1: Red C1: 8 D1: Y E1: 48
B2: Magenta C2: 2 D2: Y E2: 16
B3: Green C3: D3: E3: 30
B4: Blue C4: D4: E4: 12

Please notice A3 and A4 have no number before the Y so the only number
after the color name must go to column E.

This is really a tough one for me. Any help from you experts would be
greatly appreciated.

Henry