Difference between revisions of "Manuals/calci/LEN"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"><font size="2"><font face="Arial"> <font color="#484848"> </font></font></font> <font color="#484848"><font face="Ari...") |
(No difference)
|
Revision as of 21:39, 24 October 2013
LEN(txt)
LEN calculates the number of characters in a text string.
LENB calculates the number of bytes used to represent the characters in a text string.
Note LEN works with languages that use the single-byte character set (SBCS)
LEN
let’s see an example in (Column1 Row 1)
I.e.=LEN(C1R1)
=LEN(“world”) is 5
Syntax
Examples
Description
Column1 | Column2 | Column3 | Column4 | |
Row1 | world | 5 | ||
Row2 | ||||
Row3 | ||||
Row4 | ||||
Row5 | ||||
Row6 |