How to use the LEN function in Microsoft Excel to count the number of characters in a cell containing text.
The function 'LEN' requires a cell containing text, for example LEN(A1) where A1 has text. One thing to note about the LEN function is that any character will be counted this includes spaces between words and periods.
