SpreadJS 13
SpreadJS Documentation / Formula Reference / Formula Functions / LENB
In This Topic
    LENB
    In This Topic

    This function returns the number of bytes used to represent the characters in a text string.

    Syntax

    LENB(text_value)

    Arguments

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

    Remarks

    The LENB function counts 2 bytes per character, but this happens only when a DBCS language is set as the default language.

    Data Types

    Accepts string data. Returns numeric data.

    Examples

    LENB("rheabuto") gives the result 8.

    LENB("rosy") gives the result 4.

    See Also