=LEN(A1)-LEN(SUBSTITUTE(A1,"O",""))

________________________________________
From: [email protected] [mailto:[email protected]] On Behalf
Of [email protected]
Sent: Sunday, August 22, 2010 4:14 PM
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