Manuals/calci/LENB

LENB(txt)

• where, $txt$ is a text string whose length is to be determined.

LENB() returns the number of bytes used to represent characters in a text string.

Description

LENB(txt)

• LENB() counts 2 byte per character when default language is set as Double-byte Character Set (DBCS). Else LENB() counts 1 byte per character similar to LEN.
• Languages such as Japanese, Chinese, Korean etc support DBCS.
• $txt$ can be any string containing characters, numbers, symbols, blank spaces etc.
• If argument $txt$ is directly entered in the command, it should be enclosed in double quotes (e.g. "Name").

Examples

ABC#DEF
***
1 3.123

=LENB(A1) : Calculates the number of characters in a string referenced to cell A1. 
Displays 7 as the output. Character '#' is also counted.
=LENB(A3) : Calculates the number of characters in a string referenced to cell A3. 
Displays 7 as the output. Space and decimal point are also counted.
=LENB("<!#!>") : Displays 5 as the output.

Need to give examples with characters/language supporting DBCS

Related Videos

LEN function

See Also

• LEN

References

• String
• Double-byte Character Set