LENB

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

tip

This function is available since LibreOffice 4.2.


αžœαžΆαž€αŸ’αž™β€‹αžŸαž˜αŸ’αž–αž“αŸ’αž’β€‹β€‹

LENB("Text")

αž’αžαŸ’αžαž”αž‘ αž‚αžΊβ€‹αž‡αžΆβ€‹αž’αžαŸ’αžαž”αž‘β€‹αžŠαŸ‚αž›β€‹αž”αŸ’αžšαžœαŸ‚αž„β€‹αžšαž”αžŸαŸ‹β€‹αžœαžΆβ€‹αžαŸ’αžšαžΌαžœβ€‹αž”αžΆαž“β€‹αž€αŸ†αžŽαžαŸ‹Β αŸ”

αž§αž‘αžΆαž αžšαžŽαŸ

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.

Please support us!