count

S

stevekirk

hi,

i am trying to count the number of certain charectors in a field
example below

press/three/press

count the number of "p" and the number of "e"

thanks steve
 
P

prabhuraaman

Use the FIND worksheet function

To find "p" and "e"

Enter your text in a "press/three/press" in a cell(A1)
Use FIND in another cell
=FIND("p",A1)
In another cell
=FIND"("e",A1)

You could find out more on Microsoft Excel help
Also spare time to have a look at my new Excel Blog
http://xlmaster.blogspot.com
 
B

Bob Phillips

=LEN(A2)-LEN(SUBSTITUTE(A2,"e",""))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
A

Arjuna

hi,
use below given function:

=+LEN(B19)-LEN(SUBSTITUTE(B19,"a",""))

Note: counting occurance of "a" in B19
 
Top