Re: [belajar-excel] Menginsert KOMA setiap 5 karakter

2010-05-17 Thread HerrSoe
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 >

Re: [belajar-excel] Menginsert KOMA setiap 5 karakter

2010-05-16 Thread 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

Re: [belajar-excel] Menginsert KOMA setiap 5 karakter

2010-05-16 Thread anton suryadi
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

[belajar-excel] Menginsert KOMA setiap 5 karakter

2010-05-14 Thread HerrSoe
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