Manuals/calci/LEN

LEN (Text)


  • where, 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).
  •   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.

Related Videos

LEN function

See Also

References