43
Excel Formulas to count specific characters in a cell ~ Quick Method!!
Sometimes, you may need to count how many times a specific character appearing in a cell. In this tutorial, we are going to look at how to count specific characters in a cell in Excel. Let’s get into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

- If you want to count how many times a specific character appears in a cell, you can use the below formula.
=LEN(A1)-LEN(SUBSTITUTE(A1,”a”,””))
- LEN – In Excel, the LEN function is used to find the length of the text string.
- SUBSTITUTE – This function helps to replace existing text with new text in a text string when you want to replace text based on its content, not position. Read more on the SUBSTITUTE function.
- A1 – It represents the input value.
- Comma symbol (,) – It is a separator that helps to separate a list of values.
- Parenthesis () – The main purpose of this symbol is to group the elements.
- Minus Operator (-) – This symbol will help to subtract any two values.
Let’s consider the below example image.
- Here we will enter the input values in Column B.
- Now we need to count the number of certain characters in a cell.

- Select any cell and type the above-given formula.

- Finally, press the ENTER key to get the result out, if you need, drag the fill handle over range to apply the formula.

Here, we have described the simple formulas to count specific characters in a cell in Excel. If you have any questions , feel free to comment.
Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **
43