47
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

=LEN(A1)-LEN(SUBSTITUTE(A1,”a”,””))
Let’s consider the below example image.



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 *!! **
47