| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| Setting the number of decimal places for a text box. | Excel Discussion (Misc queries) | |||
| How do I count wildcard text meeting certain criteria in EXCEL? | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Linear Mode
