Search
Clear search
Close search
Google apps
Main menu

LEN

Returns the length of a string.

Sample Usage

LEN(A2)

LEN("lorem ipsum")

Syntax

LEN(text)

  • text - The string whose length will be returned.

Notes

  • LEN counts all characters, even spaces and nonprinting characters. In cases where LEN returns unexpected values, ensure 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

Mary is a Docs & Drive expert and author of this help page. Leave her feedback below about the page.

Was this article helpful?
How can we improve it?