Thread
:
counting occurances of a char. within a text string/cell
View Single Post
#
3
Posted to microsoft.public.excel.programming
Chip Pearson
external usenet poster
Posts: 7,247
counting occurances of a char. within a text string/cell
Justin,
Try something like
NumChars = Len(S) - Len(Replace(S, "*", ""))
where S is your string.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Justin Ater" wrote in message
...
Can anyone recommend a easy method for programmatically
determining the
number of times a character occurs within a single cell (e.g.,
the character
"*" occurs 5 times in text "A*B*C*D*E*F"). Thanks,
Justin
Reply With Quote
Chip Pearson
View Public Profile
Find all posts by Chip Pearson