Manuals/calci/LENB

LENB (Text)


  • where, is a text string whose length is to be determined.
    • LENB(), returns the number of characters in a text string.LENB is intended for use with languages that use the double-byte character set (DBCS).

Description

LENB(Text)

  • 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.
  •   can be any string containing characters, numbers, symbols, blank spaces etc.
  • If argument   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

References