Spread Formula Reference
Formula Functions / Functions H to L / LEN
In This Topic
    LEN
    In This Topic

    This function returns the length of, the number of characters in, a text string.

    Syntax

    LEN(value)

    Arguments

    The argument is the text whose length you want to find. Spaces count as characters.The argument must be a string or a cell reference to a string value.

    Data Types

    Accepts string data. Returns numeric data.

    Examples

    LEFT(A2,LEN(A2)–1)

    LEN(""FarPoint Technologies, NC"") gives the result 25

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    CHAR | TRIM | Text Functions