Manuals/calci/LENB

Revision as of 10:40, 13 January 2014 by Swapna (talk | contribs)

LENB(txt)

  • where,   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.
  •   can be any string containing characters, numbers, symbols, blankspaces 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.

See Also

References