Data separation by formula

[nur2544]

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

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

[daffodil11]

B1:

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

Copy over and down

[nur2544]

hi daffodil11, Thanks for reply , yes i am getting desire output for CELL B, would you please work for CELL C , & CELL D . as i need total three formula for getting my desire output.

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

[daffodil11]

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))

[nur2544]

hi daffodil11, it works perfectly , my requirements is fulfillment now, thanks for your valuable time for me , I really appreciated your nice job…