Terima kasih, Pak Kid
________________________________ From: Kid Mr. <[email protected]> To: [email protected] Sent: Wednesday, August 8, 2012 11:52 AM Subject: Re: [belajar-excel] Pisahkan data tanpa kolum bantu Posting Key : =Left( data_asli , 2 ) GL : =Trim( Mid( data_asli , 3 ,99 ) ) Wassalam, Kid. 2012/8/8 Emi <[email protected]> > > >Dear para suhu, >Gimanacaranya 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

