Coba formula ini:
F2=SUBSTITUTE(LEFT(SUBSTITUTE(MID(A2,32,10)," ",REPT(" ",99)),2*99), " ","")
G2=--MID(SUBSTITUTE(A2," ",REPT(" ",99)),IF(MID(A2,32,1)=" ",4,3)*99,99)
H2=--MID(SUBSTITUTE(A2," ",REPT(" ",99)),IF(MID(A2,32,1)=" ",5,4)*99,99)
From: [email protected] [mailto:[email protected]]
On Behalf Of Emi
Sent: Thursday, October 04, 2012 11:52 AM
To: [email protected]
Subject: [belajar-excel] Split data ke kolum
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
<<image001.jpg>>
<<image002.jpg>>
