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