Spread Formula Reference
Formula Functions / Functions H to L / 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.

    Version Available

    This function is available in Spread for Windows Forms 11.0 or later.