Difference between revisions of "Manuals/calci/LENB"
Jump to navigation
Jump to search
| Line 43: | Line 43: | ||
=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(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. | =LENB("<!#!>") : Displays '''5''' as the output. | ||
| + | <font color ="Red">Need to give examples with characters/language supporting DBCS </font> | ||
== See Also == | == See Also == | ||
Revision as of 16:13, 27 January 2014
LENB(txt)
- where, is a text string whose length is to be determined.
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, 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