Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting specific letters in a cell
How do I count the number of specific letters in a given cell? For example
if a cell has the words "Have a nice day!" I would only want to count only the letter "a." Is there some sort of IF-LEN-combo function? Help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting specific letters in a cell
Try this:
=LEN(A1)-LEN(SUBSTITUTE(A1,"a","")) Hope this helps. Pete On Jul 3, 4:35*pm, Sandy wrote: How do I count the number of specific letters in a given cell? *For example if a cell has the words "Have a nice day!" I would only want to count only the letter "a." *Is there some sort of IF-LEN-combo function? *Help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting specific letters in a cell
Try this:
=LEN(A1)-LEN(SUBSTITUTE(UPPER(A1),"A","")) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Sandy" wrote in message ... How do I count the number of specific letters in a given cell? For example if a cell has the words "Have a nice day!" I would only want to count only the letter "a." Is there some sort of IF-LEN-combo function? Help. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting specific letters in a cell
This works for:
"Have a nice day!" As well as: "A nice day was had by all!" -- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "RagDyeR" wrote in message ... Try this: =LEN(A1)-LEN(SUBSTITUTE(UPPER(A1),"A","")) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Sandy" wrote in message ... How do I count the number of specific letters in a given cell? For example if a cell has the words "Have a nice day!" I would only want to count only the letter "a." Is there some sort of IF-LEN-combo function? Help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting letters in excel cell | Excel Discussion (Misc queries) | |||
Can I recognize the specific letters in a cell using formulas? | Excel Worksheet Functions | |||
Counting letters in a cell | Excel Discussion (Misc queries) | |||
Counting the number of letters in a cell | Excel Discussion (Misc queries) | |||
Counting specific text in a cell | Excel Worksheet Functions |