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

LOWER(text)

 
 Converts all uppercase letters in a text string to lowercase.

 textThe text string you want to convert to lowercase.

 REMARKS
 
  		• The "text" can be a cell reference.
     
  		• Any characters that are not text will not altered.
     
  		• This function is similar to the PROPER() and UPPER() functions.

     EXAMPLES
     
     A
    1=LOWER("SOME TEXT") = some text
    2=LOWER("E. E. Cummings") = e. e. cummings
    3=LOWER("Apt. 2B") = apt. 2b
    4=LOWER("123456789") = 123456789
    		 
     Functions - L | Index - L | Text Manipulation | Office Online 

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