Returns the number of characters in the specified text.
Syntax
 Copy Code
|
|---|
LEN( Text text ) → Integer |
Parameters
- text
- Required. The text whose length to find.
Remarks
Returns the number of characters in text. If text is a number, it is automatically converted to text, including a fractional part and decimal separator if necessary.
Example
| Formula
Copy Code
|
|---|
=LEN(A1&A2) |
See Also
Function Reference
TEXT Function
ISTEXT Function
LEFT Function
MID Function
RIGHT Function