# Documentation/Calc Functions/LEN

Other languages:

LEN

Text

## Summary:

Determines the number of characters (including spaces) in a supplied text string.

LEN(Text)

## Returns:

Returns a non-negative integer that is the number of characters in the supplied string.

## Arguments:

Text is a text string (in quotation marks), a number, or a reference to a cell containing one of those types, whose length in characters is to be determined.

None.

## Examples:

Formula Description Returns
=LEN("Good afternoon") Here the function returns the length of the string as 14 (single-byte) characters. 14
=LEN("Ｇｏｏｄ　ａｆｔｅｒｎｏｏｎ") Here the function returns the length of the string as 14 (double-byte) characters. 14
=LEN(D1) where cell D1 contains the number 12345.67. Here the function returns 8. 8
=LEN("12,345.67") Here the function returns 9. Note that in this case the number is passed as a string - LEN reports an error if the quotation marks are omitted because the number includes a comma digit group separator. 9
=LEN("") Here the function returns 0, since the argument is the empty string. 0

LEN