Thread: how to separate data from 1 column to 3 column

99% Job done.. Don't know how to determine BATU PAHAT as one word...

Alternative...

E2: =IF((LEN($A2)-LEN(SUBSTITUTE($A2," ","")))<2,"",LEFT($A2,FIND(" ",$A2)-1))

F2: =IF($E2="",$A2,REPLACE(LEFT($A2,FIND(" ",$A2,LEN($E2)+2)),1,LEN($E2)+1,""))

G2: =IF($E2="","",REPLACE($A2,1,FIND(" ",$A2,2+LEN($E2)),""))