| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count occurences of a letter in a cell
Is there a formula to count how many letters "i" there are in a cell?
Example: if the cell contain the word "limitation", the result is 3 Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count occurences of a letter in a cell
Jair Batista wrote:
Is there a formula to count how many letters "i" there are in a cell? Example: if the cell contain the word "limitation", the result is 3 Thanks! Total occurrences of exact case =LEN(A1)-LEN(SUBSTITUTE(A1,B1,"")) Total occurrences of either case =LEN(A1)-LEN(SUBSTITUTE(SUBSTITUTE(A1,LOWER(B1),""),UPPER(B 1),"")) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count occurences of a letter in a cell
"Glenn" wrote: Jair Batista wrote: Is there a formula to count how many letters "i" there are in a cell? Example: if the cell contain the word "limitation", the result is 3 Thanks! Total occurrences of exact case =LEN(A1)-LEN(SUBSTITUTE(A1,B1,"")) Total occurrences of either case =LEN(A1)-LEN(SUBSTITUTE(SUBSTITUTE(A1,LOWER(B1),""),UPPER(B 1),"")) Thank you Glenn! It worked well! Jair |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to count the number of occurences of a letter ? | Excel Discussion (Misc queries) | |||
| Excel= can I count how many times letter a appears in 1 cell? | Excel Worksheet Functions | |||
| Count # of Occurences | Excel Discussion (Misc queries) | |||
| How do I count the number of times a letter is used in a cell? | Excel Discussion (Misc queries) | |||
| count a number range and a letter in a cell | Excel Worksheet Functions | |||
Linear Mode
