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
![](https://res.cloudinary.com/practicaldev/image/fetch/s--AW9JWOcv--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://geekexcel.com/wp-content/uploads/2021/06/Count-specific-characters-in-a-cell.png)
- 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.
![](https://res.cloudinary.com/practicaldev/image/fetch/s--C_qBHsAa--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://geekexcel.com/wp-content/uploads/2021/06/Input-Ranges-11.png)
- Select any cell and type the above-given formula.
![](https://res.cloudinary.com/practicaldev/image/fetch/s--lHS-X__P--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://geekexcel.com/wp-content/uploads/2021/06/Enter-the-formula-16.png)
- Finally, press the ENTER key to get the result out, if you need, drag the fill handle over range to apply the formula.
![](https://res.cloudinary.com/practicaldev/image/fetch/s--HBxuMIvM--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://geekexcel.com/wp-content/uploads/2021/06/Result-15.png)
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