LEN

Returns the length of a string.

Sample usage

LEN(A2)

LEN('lorem ipsum')

Syntax

LEN(text)

• text – The string for which the length will be returned.

Notes

• LEN counts all characters, even spaces and non-printing characters. In cases where LEN returns unexpected values, make sure that there are no such characters in text.

See also

LEFT: Returns a substring from the beginning of a specified string.

RIGHT: Returns a substring from the end of a specified string.

MID: Returns a segment of a string.

Examples