writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − <div id="6SpaceContent" class="zcontent" align="left"><font size="2"><font face="Arial"> <font color="#484848"> </font></font></font>+ − + − </div>+ − ---- − <div id="1SpaceContent" class="zcontent" align="left"> − <font color="#484848"><font face="Arial, sans-serif"><font size="2">LEN calculates the number of characters in a text string.</font></font></font>+ − <font color="#484848"><font face="Arial, sans-serif"><font size="2">LENB calculates the number of bytes used to represent the characters in a text string.</font></font></font>+ − <font color="#ff0000"><font face="Arial, sans-serif"><font size="2">'''Note'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2"> LEN works with languages that use the single-byte character set (SBCS)</font></font></font>+ − + − ----+ − + − LEN+ − </div></div> − ---- − <div id="8SpaceContent" class="zcontent" align="left"> − − <font color="#484848"><font face="Arial, sans-serif"><font size="2">let’s see an example in (Column1 Row 1)</font></font></font> − − <font color="#484848"><font face="Arial, sans-serif"><font size="2">I.e.=LEN(C1R1)</font></font></font> − − <font color="#484848"><font face="Arial, sans-serif"><font size="2"><nowiki>=LEN(“world”) is 5</nowiki></font></font></font> − − </div> − ---- − <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></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> − ---- + − | Column1+ − + − | Column3 − | Column4 − + − + − + − + − | class=" sshl_f " | − + − + − + − <div id="2Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" title="Click and Drag over to AutoFill other cells."></div>+ − − | − | Row3+ − + − |+ − | − | − |- class="even" − | Row4 − | − | − | − | class=" " | − − | class=" " | Row5 − | − | − | − − − | Row6 − | − | − | − − + − ----+ + + + + + + + + + + + +
no edit summary
=LEN(txt)=
<font color="#484848"><font face="Arial"><font size="2">'''LEN'''</font><font size="2">(</font><font size="2">'''txt'''</font><font size="2">)</font></font></font>
*where, <math>txt</math> is a text string whose length is to be determined.
LEN() counts the number of characters in a text string.
== Description ==
LEN(txt)
e.g. LEN("String") displays '''6''' as a result.
</div>
*LEN counts 1 byte per characters. LEN works with the languages that use 'Single Byte Character Set' (SBCS).
*<math>txt</math> can be any string containing characters, numbers, symbols, blank space etc.
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
*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" |Wel-Come
| class=" " |
| class=" " |
| class=" " |
| class=" " | Column2
|- class="odd"
|- class="odd"
| class=" " | Row1
| class="sshl_f" |Apple Orange
| class="sshl_f " | world
| class=" " |
| class="sshl_f" | 5
| class=" " |
|
|- class="even"
|- class="even"
| class=" " | Row2
| class="sshl_f" |123*123
| class="sshl_f" |
| class=" " |
| class="sshl_fSelectTD SelectTD " |
| class=" " |
|
|- class="odd"
|- class="odd"
| class="sshl_f" |
| class=" sshl_f " |
| class=" " |
| class=" " |
|- class="odd"
|
|- class="even"
|
|}
|}
<div align="left">[[Image:calci1.gif]]</div></div>
=LEN(A1) : Calculates the number of characters in a string referenced to cell A1. Displays '''8''' as the output. Character '-' is also counted.
=LEN(A2) : Calculates the number of characters in a string referenced to cell A2. Displays '''12''' as the output. Space Character is also counted.
=LEN(A3) : Calculates the number of characters in a string referenced to cell A3. Displays '''7''' as the output.
=LEN("<!#!>") :Displays '''5''' as the output.
=LEN(A1&A2) : Adds the count of two strings referenced to cells A1 and A2. Displays '''20''' as the output.
=LEN(A3&"123") : Adds the count of two strings referenced to cell A1 and "123". Displays '''10''' as the output.
== See Also ==
*[[Manuals/calci/LENB | LENB]]
== References ==
*[http://en.wikipedia.org/wiki/String_(computer_science) String]