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

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

If this problem persists, please contact our support.