Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Text > LEN
 

LEN(text)

 
 Returns the number of characters in a text string.

 textThe text string you want to find the length of.

 REMARKS
 
  		• Any blank spaces are counted as individual characters.
     
  		• This function returns the length of the displayed text or value and not the underlying value.
     
  		• This function is often used alongside the LEFT() and RIGHT() functions.
     
  		• There is also a LENB() function which can be used with languages that use the double-byte character set.

     EXAMPLES
     
     A
    1=LEN("some text") = 9
    2=LEN(" some text") = 10
    3=LEN("") = 0
    4=LEN(20) = 2
    5=LEN("123456789") = 9
    6=LEN("00020") = 5
    7=LEN("00020") = 5
    		 
     Functions - L | Index - L | Text Manipulation | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top