Counting specific characters in Excel 1] Count characters using the LEN formula For single cell To count the characters in a single cell, the text function in Excel, LEN comes in handy.

If you want to count the frequency of a text in Excel, you can use the Countif function. This article explains the step-by-step procedure.