LEN

Returns the number of characters in the specified text.

Syntax

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

=LEN(A1&A2)

See Also

Function Reference
TEXT Function
ISTEXT Function
LEFT Function
MID Function
RIGHT Function