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.
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 ...Originally Posted by andrewturek
=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.
BenjieLop
Houston, TX
That's fantastic, thank you indeed. As always, obvious when you know how!
Andrew
You are welcome ... thank you for the feedback.Originally Posted by andrewturek
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks