Data separation by formula

Dear all, Data separation by formula
CELLA having data like below

3RB2       AIS     130719  134140
56RB2                        RDI                     140619  124341
872RB2          LOFYT                   130619  154346
6589RBL2                LOS                     120519  114346
KL5252B          NONE                     150619  104345
56RB2                      EQUEP                     130619  174326
872RB2             NONEA        110619  194346
DH012A                             ERATE     130610  204342

I would like to get in the CELL B , CELL C, CELL D

CELL B    CELL C      CELL D
3RB2	AIS	130719  1341
56RB2	RDI	140619  1243
872RB2	LOFYT	130619  1543
6589RBL2	LOS	120519  1143
KL5252B	NONE	150619  1043
56RB2	EQUEP	130619  1743
872RB2	NONEA	110619  1943
DH012A	ERATE	130610  2043

B1:

=TRIM(MID(SUBSTITUTE(TRIM($A1)," ",REPT(" ",100)),MAX((COLUMN(A1)-1)*100,1),100))

Copy over and down

B1
=trim(mid(substitute(trim($a1)," ",rept(" ",100)),max((column(a1)-1)*100,1),100))

c1
=trim(mid(substitute(trim($a1)," ",rept(" ",100)),max((column(b1)-1)*100,1),100))

d1
=trim(mid(substitute(trim($a1)," ",rept(" ",100)),max((column(c1)-1)*100,1),200))