Posting Key :
=Left( data_asli , 2 )

GL :
=Trim( Mid( data_asli , 3 ,99 ) )

Wassalam,
Kid.

2012/8/8 Emi <[email protected]>

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