Ysh: Pak Kid, Pak Anton, Mbak Siti & group member sadayana...
Tarema kaseh... kiriman UDF nya yg hebat-hebat...
Semuanya langsung berguna di lapangan, dan berguna untuk bahan
pelajaran : hao tu mik an YU-DI-EPF
*[belajar excel] top markotop ! *gitu loch...!!
HerrSoe
2010/5/17 anton suryadi
>
1:19:51 PM
Subject: Re: [belajar-excel] Menginsert KOMA setiap 5 karakter
Function Insret(t As Range, x As String, Optional y As String = "") As String
n = t
z = Len(n) - x
Do While z > 0
n = Left(n, z) & y & Right(n, Len(n) - z)
z = z - x
Loop
Insret = n
End
ilkan 12,3456,7890
=Insret(A1,3,"/") menghasilkan 1/234/567/890
>semoga bermanfaat
From: Mr. Kid
To: belajar-excel@yahoogroups.com
Sent: Sun, May 16, 2010 2:39:45 AM
Subject: Re: [belajar-excel] Menginsert KOMA setiap 5 karakter
Dulu pernah buat penyusun
Dear Group,
Bagaimanakah cara termudah untuk memberi KOMA tiap 5 karakter
dihitung dari kanan; contohnya seperti ini
*input (type data: text)
* *output (type data: text)
* *1023456789012345* *0,12345,67890,12345* *
000123000456000789000321000* *00,01230,00456,00078,90003,21000*
formula
4 matches
Mail list logo