Len

Syntax

Len(Text)

Text. String the length of which should be calculated.

NOTE. To determine the parameter, specify either the parameter value or the cell address where it is located.

It returns string length.

Formula	Result	Description
=Len("12345")	5	The number of characters in the 12345 string.
=Len(B6)	3	The length of the string located in the B6 cell. The B6 cell contains the zxc value.