count

[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

[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

[Bob Phillips]

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

--
HTH

Bob Phillips

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

"stevekirk" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[stevekirk]

thanks for your help working great

[Arjuna]

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
>
>