| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
To count an alphabet in a cell
Hi,
Can someone help me, my issue is, if for example there is text entered in one cell like "aabcd" .I want to count the number time "a" appearing in the cell. Thanks Rajesh Kamath |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
To count an alphabet in a cell
Try using
=(LEN(A1) - LEN(SUBSTITUTE(A1, B1, ""))) / LEN(B1) where A1 contains the cell you want to check, and B1 the letter that you want to count. -- Regards Juan Pablo González "Rajesh Kamath" wrote in message ... Hi, Can someone help me, my issue is, if for example there is text entered in one cell like "aabcd" .I want to count the number time "a" appearing in the cell. Thanks Rajesh Kamath |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
To count an alphabet in a cell
=LEN(A1)-LEN(SUBSTITUTE(A1,"a",""))
-- HTH RP "Rajesh Kamath" wrote in message ... Hi, Can someone help me, my issue is, if for example there is text entered in one cell like "aabcd" .I want to count the number time "a" appearing in the cell. Thanks Rajesh Kamath |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to count lower case alphabet? | Excel Discussion (Misc queries) | |||
| Seperate Alphabet and numbers in a cell | Excel Discussion (Misc queries) | |||
| auto format cell to enter data alphabet in column | Excel Worksheet Functions | |||
| How do I change my cell reference columns from number to alphabet? | Excel Worksheet Functions | |||
| Greek alphabet | Excel Discussion (Misc queries) | |||
Linear Mode
