Software & Apps MS Office How to Convert Text to Upper, Lower, or Proper Case in Excel Built-in functions facilitate text case conversions by Ted French Writer Former Lifewire writer Ted French is a Microsoft Certified Professional who teaches and writes about spreadsheets and spreadsheet programs. our editorial process Ted French Updated on November 18, 2019 MS Office Excel Word Powerpoint Outlook Tweet Share Email Excel includes several built-in, specialized functions that modify the case of letters within a text string: LOWER(): Converts text to all lower case (small letters)UPPER(): Converts text all to upper case (capital letters)PROPER(): Converts text to title form by capitalizing the first letter of each word The functions and their syntax work for all versions of Microsoft Excel. UPPER, LOWER, and PROPER Functions' Syntax and Arguments Wikimedia Commons A function's syntax refers to the layout of the function and includes the function's name, brackets, comma separators, and arguments. The syntax for the UPPER() function is: =UPPER(text) The syntax for the LOWER() function is: =LOWER(text) The syntax for the PROPER() function is: =PROPER(text) Each of these functions accept a single argument: A cell referenceA word or words enclosed in quotation marksA formula that outputs text Example Usage If cell A1 contained the text Success, then the formula =UPPER(A1) returns SUCCESS. Likewise, the following formula =LOWER("My CaT iS aWeSoMe") returns my cat is awesome. If you need a refresher for manually entering formulas, check out our step-by-step guide to formulas. We've also prepared a tutorial about the uses and examples of Excel functions. Use VBA for Changing Text Case Using formulas for very large spreadsheets or frequently updated data is less efficient than using a Visual Basic for Applications macro. Although VBA is more of an advanced programming technique, Microsoft published a beginner-friendly introduction to VBA for Excel that can get you started.