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