Difference between revisions of "Manuals/calci/LEN"
Jump to navigation
Jump to search
| Line 47: | Line 47: | ||
=LEN(A1&A2) : Adds the character length 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 character length 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. | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|BI1otcs3nJE|280|center|LEN function}} | ||
== See Also == | == See Also == | ||
Revision as of 10:10, 10 May 2015
LEN(txt)
- where, is a text string whose length is to be determined.
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.
- LEN() counts 1 byte per character. LEN() works with the languages that use 'Single Byte Character Set' (SBCS).
- can be any string containing characters, numbers, symbols, blank space etc.
- If argument is directly entered in the command, it should be enclosed in double quotes (e.g. "Name").
Examples
| Wel-Come | ||
| Apple Orange | ||
| 123*123 | ||
=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 character length of two strings referenced to cells A1 and A2. Displays 20 as the output.
=LEN(A3&"123") : Adds the character length of two strings referenced to cell A1 and "123". Displays 10 as the output.