View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stan Sitek Stan Sitek is offline
external usenet poster
 
Posts: 1
Default Count occurrences of text within a cell

I need to count the number of characters repeating within a cell. For
example, assuming the following in range A1 through A4:

eee
ee
aaaae
af

A count of "e" would return

3
2
1
0