Documentation/Calc Functions/LENB

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

LENB

Category:

Text

Summary:

For double-byte character set (DBCS) languages, returns the number of bytes used to represent the characters in a text string.

Syntax:

LENB("Text")

Returns:

Arguments:

Text is the text whose length is to be determined.

Additional details:

Examples:

LENB("中") returns 2 (1 DBCS character consisting of 2 bytes).

LENB("中国") returns 4 (2 DBCS characters each consisting of 2 bytes).

LENB("office") returns 6 (6 non-DBCS characters each consisting of 1 byte).

=LENB("Good Afternoon") returns 14.

=LENB(12345.67) returns 8.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: