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 >> >> >> >> >
re-Split data ke kolum.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
