Open main menu
Home
Random
Log in
Settings
About ZCubes Wiki
Disclaimers
ZCubes Wiki
Search
Changes
← Older edit
Newer edit →
Manuals/calci/LEN
(view source)
Revision as of 15:03, 13 January 2014
22 bytes added
,
15:03, 13 January 2014
no edit summary
Line 45:
Line 45:
=LEN(A3) : Calculates the number of characters in a string referenced to cell A3. Displays '''7''' as the output.
=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("<!#!>") :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(A1&A2) : Adds the
character length
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.
+
=LEN(A3&"123") : Adds the
character length
of two strings referenced to cell A1 and "123". Displays '''10''' as the output.
== See Also ==
== See Also ==
Swapna
writer
2,661
edits