View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mikelee101[_3_] mikelee101[_3_] is offline
external usenet poster
 
Posts: 3
Default counting instances of a character within a string

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