[*] Any
*
Any
[053] Ordinary
Share Capital
053
Ordinary Share Capital
[054]
Unappropriated Profit
054
Unappropriated Profit
[011] Cash on
Hand
011
Cash on Hand
[016]
Creditors & Provisions
016
Creditors & Provisions
[PnL] Income
Statement Account
PnL
Income Statement Account
[kas] Kas
& Setara Kas
kas
Kas & Setara Kas
[investasi]
Investasi Sementara
investasi
Investasi Sementara
[Piutangusaha]
Piutang Usaha
Piutangusaha
Piutang Usaha
[Piutanglain]
Piutang Lain-Lain
Piutanglain
Piutang Lain-Lain
[Persediaan]
Persediaan
Persediaan
Persediaan
[Biayadm]
Biaya Dibayar Dimuak
Biayadm
Biaya Dibayar Dimuak
[Pajakdm]
Pajak Dibayar Dimuka
Pajakdm
Pajak Dibayar Dimuka
[Aktivapajak]
Aktiva Pajak Tangguhan
Aktivapajak
Aktiva Pajak Tangguhan
[Aktivatetap]
Akiva Tetap
Aktivatetap
Akiva Tetap
=MID(A2,2,FIND("]",A2,1)-2)
=MID(A2,FIND("]",A2,1)+1,LEN(A2)-(FIND("]",A2,1)))
=MID(A3,2,FIND("]",A3,1)-2)
=MID(A3,FIND("]",A3,1)+1,LEN(A3)-(FIND("]",A3,1)))
=MID(A4,2,FIND("]",A4,1)-2)
=MID(A4,FIND("]",A4,1)+1,LEN(A4)-(FIND("]",A4,1)))
=MID(A5,2,FIND("]",A5,1)-2)
=MID(A5,FIND("]",A5,1)+1,LEN(A5)-(FIND("]",A5,1)))
=MID(A6,2,FIND("]",A6,1)-2)
=MID(A6,FIND("]",A6,1)+1,LEN(A6)-(FIND("]",A6,1)))
=MID(A7,2,FIND("]",A7,1)-2)
=MID(A7,FIND("]",A7,1)+1,LEN(A7)-(FIND("]",A7,1)))
=MID(A8,2,FIND("]",A8,1)-2)
=MID(A8,FIND("]",A8,1)+1,LEN(A8)-(FIND("]",A8,1)))
=MID(A9,2,FIND("]",A9,1)-2)
=MID(A9,FIND("]",A9,1)+1,LEN(A9)-(FIND("]",A9,1)))
=MID(A10,2,FIND("]",A10,1)-2)
=MID(A10,FIND("]",A10,1)+1,LEN(A10)-(FIND("]",A10,1)))
=MID(A11,2,FIND("]",A11,1)-2)
=MID(A11,FIND("]",A11,1)+1,LEN(A11)-(FIND("]",A11,1)))
=MID(A12,2,FIND("]",A12,1)-2)
=MID(A12,FIND("]",A12,1)+1,LEN(A12)-(FIND("]",A12,1)))
=MID(A13,2,FIND("]",A13,1)-2)
=MID(A13,FIND("]",A13,1)+1,LEN(A13)-(FIND("]",A13,1)))
=MID(A14,2,FIND("]",A14,1)-2)
=MID(A14,FIND("]",A14,1)+1,LEN(A14)-(FIND("]",A14,1)))
=MID(A15,2,FIND("]",A15,1)-2)
=MID(A15,FIND("]",A15,1)+1,LEN(A15)-(FIND("]",A15,1)))
=MID(A16,2,FIND("]",A16,1)-2)
=MID(A16,FIND("]",A16,1)+1,LEN(A16)-(FIND("]",A16,1)))
To: [email protected]
From: [email protected]
Date: Thu, 29 Dec 2011 16:27:40 +0800
Subject: [belajar-excel] Pemisahan data
Selamat siang rekan sekalian,Mohon bantuannya tentang pemisahan
data-data. Saya lampirkan file permasalahan tersebut.Atas bantuan rekan
belajar-excel saya ucapkan terimakasih.
Ronald
