Jump to navigation Jump to search
- 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).
- 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").
=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