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