Newbie coba bantu ya:
=LEN(A1)-LEN(SUBSTITUTE(A1,"o",""))

Answer = 2. 
-----Original Message-----
From: "[email protected]" <[email protected]>
Sender: [email protected]
Date: Sun, 22 Aug 2010 09:14:21 
To: <[email protected]>
Reply-To: [email protected]
Subject: ]] XL-mania [[ menghitung character tertentu

sobat excel mania,

adakah rumus untuk mencari jumlah karakter yang hendak dicari?

misal:
pada A1 berisi kata:
SOTO BABAT
bagaimanakah rumusnya menghitung huruf O?

mohon bantuannya

terima kasih


Kirim email ke