LEN function

This Excel function returns the number of characters in a text string. The function does count spaces. It requires only 1 argument, such as the cell reference or string enclosed in quotes.

TextThe cell reference or text string in quotes.

Syntax ExampleWhat Happens
=LEN(A2)This would count the characters in cell A2.
=LEN(“The answer to the universe is 42”)This would count characters between quote marks.
LEN has determined cell A2 has 32 characters.