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