writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − <div id="6SpaceContent" class="zcontent" align="left">+ − '''LENB'''(Text)+ − where,+ − '''Text''' - is the text whose length to find.+ − </div>+ − ---- − <div id="1SpaceContent" class="zcontent" align="left">LENB returns the number of bytes used to represent the characters in a text string.LENB is intended for use with languages that use the double-byte character set (DBCS). </div> − ---- − <div id="7SpaceContent" class="zcontent" align="left"></div> − ---- − <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left"> − + + + + − </div></div>+ − ---- − <div id="8SpaceContent" class="zcontent" align="left"> − Lets see an example in (Column1, Row2) − − <nowiki>=LENB(R1C1)</nowiki> − − LENB returns 10. − − </div> − ---- − <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div> − ---- − <div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div> − ---- − <div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div> − ---- − <div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div> − ---- − |+ Default Calci − | class=" " |+ − | Column1 − | Column2 − | Column3 − | Column4 − |- class="odd" − | class=" " | Row1 − | JOHN SMITH − | class=" " | − | class=" " | − | class=" " | − |- class="even" − | class=" " | Row2 − − | class=" " | + − | Row3+ − − | class=" " | + − | Row4+ − − | class=" " | + − + − | class=" " | − | class=" " | − | class=" " | − | class=" " | − |- class="even" − | Row6 − | − | class=" " | − {| id="TABLE3_menu"+ − | align="right" | TABLE3+ − | <span align="left">[[Image:calci1.gif]]</span>+ − |+ − |+ − [[Image:bold.gif]]+ − |+ − [[Image:italic.gif]]+ − |+ − [[Image:normal.gif]] − | − [[Image:underline.gif]] − | − [[Image:border.gif]] − | − [[Image:numbers.gif]] − | − [[Image:sort.gif]] − | − − − [[Image:graphs.gif]] − | $ − |} − </div>+ − +
no edit summary
=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" | 10
| 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 SelectTD1 SelectTD1 ChangeBGColor" |
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|- class="odd"
|- class="odd"
| class=" " | Row5
| 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 ==
[[Image:formatcells.gif]]
|
*[http://en.wikipedia.org/wiki/String_(computer_science) String]
----
*[http://en.wikipedia.org/wiki/DBCS Double-byte Character Set]