What is LEN?
Returns the number of characters in a text string. Useful for data validation, text parsing, and ensuring field length compliance.
Syntax
=LEN(text)
Example
Formula: =LEN(A1)
Result: 10
How It Works
Counts all characters including spaces in the text. If A1 contains 'Hello Word', the length is 10 characters. LEN counts every character, including spaces and punctuation.