Difference between revisions of "Manuals/calci/LENB"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''LENB'''(Text) where, '''Text''' - is the text whose length to find. </div> ---- <div id="1SpaceConten...") |
|||
| Line 1: | Line 1: | ||
| − | + | =LENB(txt)= | |
| − | + | *where, <math>txt</math> 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 | + | *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. | ||
| + | *<math>txt</math> can be any string containing characters, numbers, symbols, blankspaces etc. | ||
| + | *If argument <math>txt</math> is directly entered in the command, it should be enclosed in double quotes (e.g. "Name"). | ||
| − | + | == Examples == | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
<div id="2SpaceContent" class="zcontent" align="left"> | <div id="2SpaceContent" class="zcontent" align="left"> | ||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
| − | |||
|- class="even" | |- class="even" | ||
| − | + | | class="sshl_f" |ABC#DEF | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | class="sshl_f" | | ||
| − | |||
| class=" " | | | class=" " | | ||
| class=" " | | | class=" " | | ||
| + | |||
|- class="odd" | |- class="odd" | ||
| − | + | | class="sshl_f" | | |
| − | | class="sshl_f | ||
| − | |||
| class=" " | | | class=" " | | ||
| class=" " | | | class=" " | | ||
| + | |||
|- class="even" | |- class="even" | ||
| − | + | | class="sshl_f" |1 3.123 | |
| − | | class="sshl_f | ||
| − | |||
| class=" " | | | class=" " | | ||
| class=" " | | | class=" " | | ||
| + | |||
|- class="odd" | |- class="odd" | ||
| − | | class=" | + | | class="sshl_f" | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| class=" " | | | class=" " | | ||
| class=" " | | | class=" " | | ||
|} | |} | ||
| − | + | =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 == | |
| − | + | ||
| − | + | *[[Manuals/calci/LEN | LEN]] | |
| − | + | ||
| − | + | == References == | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | [[ | ||
| − | | | ||
| − | |||
| − | |||
| − | |||
| − | + | *[http://en.wikipedia.org/wiki/String_(computer_science) String] | |
| − | - | + | *[http://en.wikipedia.org/wiki/DBCS Double-byte Character Set] |
Revision as of 10:40, 13 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, 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.