View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default How to count the number of occurrence within string?

Does anyone have any suggestions on how to count the number of occurrence
within string? For example, aa11bb5c in cell A1, and "a" in cell B1, I would
like to count the number of occurrence for the char "a" in cell B1 within
string "aa11bb5c" in cell A1, and return the number of occurrence 2 in cell
c1.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric