Skip to main content

LEN

Definition

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.

In order to use the LEN formula, start with your edited Excellentable:

Then type in the LEN formula in the area you would like to display the outcome:

By adding the values you would like to calculate the LEN formula for, Excellentable will generate the outcome:

 

A
B
1
Data
2
Princeton
3
New Jersey
4
5
10

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.