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.