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.
Argument | Description |
Text | The cell reference or text string in quotes. |
Syntax Example | What 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. |
