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

