Hello,
I'm trying to count the number of times a character appears within a string.
I thought there was a function that could do this (i.e. one line of code),
but can't seem to find it.
For example, if I have a cell that contains "27,45,8,19,13" and want to
count the commas, I'm looking for something like this:
Num = CountChars("," , Cell.Value)
where CountChars is the mystery function that I'm seeking.
I can get the result I want with the Search function and a Do...Loop, but if
there was a function it would make it much cleaner.
Thanks.
Mike
Bookmarks