Extract Data to 3 Column

[Jhon Mustofa]

hi guys....

how to extract to 3 columns....

data :
12 tahun 7 bulan 20 hari
9 tahun 12 bulan 4 hari

after formula (not vba) in 3 column (col.b,col.c,col.d):
col.b
12 tahun
9 tahun

col.c
7 bulan
12 bulan

col.d
20 hari
4 hari

any assistance, will be appreciated..

john m

[Vikas_Gautam]

Here is my way..
Drag Horizontally

=TRIM(MID(SUBSTITUTE($A1," ",REPT(" ",255)),((COLUMN(A$1)-1)*255*2)+1,255*2))

Check the attached file..

[Jhon Mustofa]

hello, Vikas Gautam, it's wonderfull

you're great..thanks a lot..