Coba bantu yah, maaf kalo kurang bagus formula nya, masih belajar :)

Posting key
=IFERROR(IF(FIND(" ",B2,1),LEFT(B2,FIND(" ",B2,1)),0),LEFT(B2,2))

GL
=IFERROR(IF(FIND(" ",B2,1),MID(B2, FIND(" ",B2,1),256)),MID(B2,3,256))

sent from my ICS GT-N7000 Note Phablet
On Aug 8, 2012 10:49 AM, "Emi" <[email protected]> wrote:

>
>
>
>  Dear para suhu,
>  Gimana caranya memisah data ke dua kolumn tanpa perlu kolum bantu.
>  Terima kasih
>  emi lestari
>
>       Data asli Kolum bantu posting key  GL 315310000001 5310000001 31
> 5310000001 315310000003 5310000003 31 5310000003 315310000027 5310000027
> 31 5310000027 315310000156 5310000156 31 5310000156 315310000161
> 5310000161 31 5310000161 40    273602     273602 40 273602 40    273616
> 273616 40 273616 40    273622     273622 40 273622 40    521112     521112
> 40 521112 50    650101     650101 50 650101 40    273602     273602 40
> 273602 40    273616     273616 40 273616 40    273622     273622 40 273622
> 40    521112     521112 40 521112 40    650101     650101 40 650101 40
> 696504     696504 40 696504 50    273622     273622 50 273622 50    542311
> 542311 50 542311 50    620102     620102 50 620102 50    650101     650101
> 50 650101
>
>
> 

Kirim email ke