Contents Of A String

[andrewturek]

Is there any way of finding how often a particular character occurs in a particular string? I know how to find out whether it occurs at all and if so how far into it, but not how often.

[BenjieLop]

Is there any way of finding how often a particular character occurs in a particular string? I know how to find out whether it occurs at all and if so how far into it, but not how often.

Try this ...

=len(A1)-len(substitute(A1,"c",""))

where cell A1 is where your string is entered and "c" is the character that you want to count in the string.

Hope this helps.

Regards.

[andrewturek]

That's fantastic, thank you indeed. As always, obvious when you know how!

Andrew

[BenjieLop]

That's fantastic, thank you indeed. As always, obvious when you know how!

Andrew

You are welcome ... thank you for the feedback.