The LEN function is a simple calculation function that counts all the characters in a given text string, including numbers, letters, special characters, and spaces. The function name (LEN) is shorthand for length, as the function output provides the total length of a text string as a number.
How to Use the LEN Function in Microsoft Excel
Unlike other Excel functions, the LEN function is extremely simple to use. It contains only one argument—the text string that you wish to calculate. You can either place this in the formula directly, or you can refer to a cell that contains the text string.
