count
 

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


--
stevekirk
------------------------------------------------------------------------
stevekirk's Profile: http://www.excelforum.com/member.php...o&userid=37328
View this thread: http://www.excelforum.com/showthread...hreadid=570686

count
 

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

count
 

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

--
HTH

Bob Phillips

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

"stevekirk" wrote
in message ...

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


--
stevekirk
------------------------------------------------------------------------
stevekirk's Profile:
http://www.excelforum.com/member.php...o&userid=37328
View this thread: http://www.excelforum.com/showthread...hreadid=570686

count
 

thanks for your help working great


--
stevekirk
------------------------------------------------------------------------
stevekirk's Profile: http://www.excelforum.com/member.php...o&userid=37328
View this thread: http://www.excelforum.com/showthread...hreadid=570686

count
 

hi,
use below given function:

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

Note: counting occurance of "a" in B19



"stevekirk" wrote:


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


--
stevekirk
------------------------------------------------------------------------
stevekirk's Profile: http://www.excelforum.com/member.php...o&userid=37328
View this thread: http://www.excelforum.com/showthread...hreadid=570686