UPPER(text) converts text to uppercase : UPPER « Text functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Text functions
  3. UPPER
Input the formula: =UPPER("ABc")
Input the formula: =UPPER
22.24.UPPER
22.24.1.UPPER(text) converts text to uppercaseUPPER(text) converts text to uppercase
22.24.2.Sentence case: Just the first word needs to start with an uppercase letter and the rest of the string is all lowercaseSentence case: Just the first word needs to start with an uppercase letter and the rest of the string is all lowercase