counting the number of occurences of a character in string

Can anyone help with a formula to count the number of times a particular character is found in a string I have been experimenting with the likes of

Please Login or Register  to view this content.

but obviously this doesnt work, VBA help doesn't say much about the count function

I wouldn't use Count as a variable name given it's a function... perhaps lngCount (Long), eg:

Please Login or Register  to view this content.

Probably this will help you out,

Please Login or Register  to view this content.

Here cnt contains the number of occurance of character “,”…

Hope you get it

Have a nice time



Chris

Hello Tryer,

Here is another method that doesn't change the original string. It also performs a non case sensitive search. It can be used to search for a single character or multiple characters.

Please Login or Register  to view this content.