Skip to main content



Returns the length of a string.

Sample Usage


LEN("lorem ipsum")



  • text - The string whose length will be returned.


  • 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:



User does not have sufficient privileges to access this Content
Learn More

JavaScript errors detected

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

If this problem persists, please contact our support.