Pada formula tersebut, fungsi rept digunakan untuk menjadi penyusun space antar kolom (bukan sebagai delimiter)
Wassalam, Kid. 2012/10/4 Emi <[email protected]> > ** > > > Terima kasih Pak Kid di atas pencerahannya. > > Saya mau tanya, apa sebenarnya fungsi REPT seperti di dalam rumus ini. > =1*LEFT(SUBSTITUTE(TRIM(MID(A2,32,99))," ",REPT(" ",99)),99) > > ------------------------------ > *From:* Kid Mr. <[email protected]> > *To:* [email protected] > *Sent:* Thursday, October 4, 2012 1:53 PM > *Subject:* Re: [belajar-excel] Split data ke kolum > > ** > > > File terlampir, siapa tahu beda setting regionalnya, malah hasilnya > formula jadi error. > > Wassalam, > Kid. > > 2012/10/4 Kid Mr. <[email protected]> > > Coba : > F2 : =1*LEFT(SUBSTITUTE(TRIM(MID(A2,32,99))," ",REPT(" ",99)),99) > G2 : =1*MID(SUBSTITUTE(TRIM(MID(A2,32,99))," ",REPT(" ",99)),99,99) > H2 : =1*MID(SUBSTITUTE(TRIM(MID(A2,32,99))," ",REPT(" ",99)),99*2,99) > > Wassalam, > Kid. > > > 2012/10/4 Emi <[email protected]> > > ** > > > > Yth guru dan teman BeExcel, > Mohon bantuan rumus untuk split data ke beberapa kolumn agar mudah > dibaca. > Terima kasih. > -Emi Lestari > > data asli Doc Date Posting date Doc Type Posting key GL code > Amount Profit ctr 2609201226092012XKUSD XXXXXX 315310000019 39.90 > 11543042 1 1471 010 1 1 26092012 26092012 XK 31 5310000019 39.90 > 11543042 2609201226092012XKUSD XXXXXX 315310000027 367.60 11543042 10 > 1471 010 10 1 26092012 26092012 XK 31 5310000027 367.60 11543042 > 2609201226092012XKUSD > XXXXXX 315310000040 99.45 11543042 3 1471 010 3 1 26092012 26092012 XK 31 > 5310000040 99.45 11543042 2609201210092012XKUSD XXXXXX > 315310000156 30.32 11543042 1 7300 032 1 1 26092012 10092012 XK 31 > 5310000156 30.32 11543042 2609201226092012XKUSD XXXXXX 40 > 273602 99.45 11543042 3 7300 032 3 1 26092012 26092012 XK 40 273602 > 99.45 11543042 2609201226092012XKUSD XXXXXX 40 273616 367.60 11543042 10 > 7300 036 10 1 26092012 26092012 XK 40 273616 367.60 11543042 > 2609201226092012XKUSD > XXXXXX 40 273622 39.90 11543042 1 7300 022 1 1 26092012 26092012 XK 40 > 273622 39.90 11543042 2609201226092012XSUSD XXXXXX 40 273602 > 22.95 11543042 3 7300 032 3 2 26092012 26092012 XS 40 273602 > 22.95 > 11543042 2609201226092012XSUSD XXXXXX 40 273616 3.23 11543042 10 7300 036 > 10 2 26092012 26092012 XS 40 273616 3.23 11543042 > 2609201226092012XSUSD > XXXXXX 50 650101 24.16 11543042 4 1471 002 4 2 26092012 26092012 XS 50 > 650101 24.16 11543042 2609201226092012XSUSD XXXXXX 50 696504 > 0.01 11543042 3 3200 022 3 2 26092012 26092012 XS 50 696504 > 0.01 11543042 > > > > > > > >
