Excel - The LEN function

January 2017




The LEN function returns the number of characters in a string.
  • Syntax: Len( text )
  • Where text: Represents the string for which you want to count the number of characters.
  • E.g: =len(A1), shall give you the number of characters making up the string in A1.
    • So if A1 contains "Kioskea", the value returned is equal to : 7
    • Note that : Spaces are considered as characters.

Related


Published by aakai1056. Latest update on January 5, 2012 at 07:16 AM by aakai1056.
This document, titled "Excel - The LEN function," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).