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.

count number of specified text within a text/cell
 

=LEN(A1) returns the number of characters in cell A1. Change the cell
address accordingly.
--
Kevin Backmann


"Vikas Kumar" wrote:

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.

count number of specified text within a text/cell
 

On Tue, 10 Oct 2006 05:15:02 -0700, Vikas Kumar
wrote:

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.




=len(a1) - len(substitute(a1,"a",""))


--ron

count number of specified text within a text/cell
 

Thank lot ron..
i got, wot i wanted..
Regards
Vikas Kumar.

"Ron Rosenfeld" wrote:

On Tue, 10 Oct 2006 05:15:02 -0700, Vikas Kumar
wrote:

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.




=len(a1) - len(substitute(a1,"a",""))


--ron

count number of specified text within a text/cell
 

On Tue, 10 Oct 2006 22:55:03 -0700, Vikas Kumar
wrote:

Thank lot ron..
i got, wot i wanted..
Regards
Vikas Kumar.

You're welcome. Thanks for the feedback.
--ron