Thread: count number of specified text within a text/cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Vikas Kumar Vikas Kumar is offline
external usenet poster
  
Posts: 9
Default count number of specified text within a text/cell
Hi
wanted to know the number of specified character/text in a word/sentence/cell.
*example:
i want to know the number of "a" used in the word "Ramchandrapura".
answer(retuns) should be:- 4

* Please help me to get the same through formula/VB code....etc.
Regards
Vikas Kumar.




Reply With QuoteReply With Quote