View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Yvonne_G Yvonne_G is offline
external usenet poster
 
Posts: 1
Default count number of appearences in cell

Trevor, TK and Dave,

Thank you for your answer, but I was looking for a formula without
substitution, which will be more practical (for me). Any ideas?

Jack.

"Jack Sons" schreef in bericht
...
Hi all,

A certain character or group of characters appears a number of times in
the content of a cell (3a appears two times in d763ah555#3abds3j. With
what formula or code can I count that number? I think I knew it once, but
I can't remember.

Jack Sons
The Netherlands