How to Count the Number of Characters in a Cell in Microsoft Excel
The formula for counting the number of characters in a cell in Excel is LEN. Using the LEN formula is the same as using other formulas in Excel: first type an equals sign (=), then type the formula (LEN), and then type an opening parenthesis. Then, click on the cell whose characters you want to count, type an opening parenthesis, and press Enter. The number of characters in that cell will immediately appear. The characters counted include all letters, numbers, punctuation marks, and other characters, even spaces. How easy is it, right? If you're still confused by the explanation above, I recommend watching the video tutorial I've provided below.