Manuals/calci/LEN

LEN (Text)

• where, $Text$ is a text string whose length is to be determined.
  • LEN(), returns the number of characters in a text string.

Description

LEN(txt)

e.g. LEN (Text) displays 6 as a result.

• LEN() counts 1 byte per character. LEN() works with the languages that use 'Single Byte Character Set' (SBCS).
• $Text$ can be any string containing characters, numbers, symbols, blank space etc.
• If argument $Text$ 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.

Related Videos

LEN function

See Also

• LENB

References

• String
• Single-byte Character Set

• List of Main Z Functions

• Z3 home