Re: [belajar-excel] Fungsi Mengetahui karakter

2011-10-04 Terurut Topik Nanang Wisma Ndaru

Re: [belajar-excel] Fungsi Mengetahui karakter

2011-10-04 Terurut Topik yusajing_ehm
Siip, Thx ya atas pencerahannya,, Sent from my BlackBerry® powered by Sinyal Kuat INDOSAT -Original Message- From: Haps Sender: belajar-excel@yahoogroups.com Date: Tue, 4 Oct 2011 16:39:47 To: Reply-To: belajar-excel@yahoogroups.com Subject: Re: [belajar-excel] Fungsi Mengetahui

Re: [belajar-excel] Fungsi Mengetahui karakter

2011-10-04 Terurut Topik yusajing_ehm
Siip, Thx ya atas pencerahannya,, Sent from my BlackBerry® powered by Sinyal Kuat INDOSAT -Original Message- From: "zainul ulum <>" Sender: belajar-excel@yahoogroups.com Date: Tue, 4 Oct 2011 15:47:00 To: Reply-To: belajar-excel@yahoogroups.com Subject: RE: [belaj

Re: [belajar-excel] Fungsi Mengetahui karakter

2011-10-04 Terurut Topik Haps
Sekedar latihan *array formula* *{*=SUM(IF(MID(A1; ROW(1:99); 1) = ","; 1))*}* Asumsi text di cell A1 misal : * "A,B,301,G2,X" *tidak lebih panjang dari 99 karakter, jika oebih panjang dari 99 karakter, angka 99 tsb harus di ganti dengan anagka yg sesuai. * Fungsi MID(A1;ROW(1:99);1) menghasilk

RE: [belajar-excel] Fungsi Mengetahui karakter

2011-10-04 Terurut Topik zainul ulum <>
Misal yang akan dicari di cell A1 =LEN(A1)-LEN(SUBSTITUTE(A1,",","")) -Original Message- From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com] On Behalf Of yusajing_...@yahoo.com Sent: Tuesday, October 04, 2011 2:57 PM To: Belajar Excel Grups Subject: [belajar-excel]