To count an alphabet in a cell

  • Thread starter Thread starter Rajesh Kamath
  • Start date Start date
R

Rajesh Kamath

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

to count an alphabet in a cell 4
Count latest number of continous not-empty cells in a row. 11
Cell Count Between Value 13
How to type each letter of the alphabet automatically in a specific color in Word? 0
Counting Bordered Cells 5
A way to count cells in a range containing text or formulas 2
Excel formula to count the number of records which contains a certaintext (wildcard) 3
Count occurances in a range. 5

Back
Top