Leading the way in Microsoft Office Development
 Home|

Excel

|Word|PowerPoint|Consultancy|Feedback|Contact 
 Excel > Functions > Text > UPPER
 

UPPER(text)

 
 Converts all lowercase letters in a text string to uppercase.

 textThe text string you want to convert to uppercase.

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

     EXAMPLES
     
     A
    1=UPPER("some text") = SOME TEXT
    2=UPPER("Better Solutions") = BETTER SOLUTIONS
    3=UPPER("BE MORE Productive") = BE MORE PRODUCTIVE
    4=UPPER("123456789") = 123456789
    5=UPPER("a1b2c3d4") = A1B2C3D4
    		 
     Functions - U | Index - U | Text Manipulation | Office Online 2003 | Office Online 2007 

     Copyright © 2010 Better Solutions Limited. All Rights Reserved.Top