How to Capitalize Text in Microsoft Excel

With Microsoft Excel’s UPPER , LOWER , and PROPER functions, you can capitalize your text as well as turn your text to lowercase or proper case. You can specify your text as a cell reference or directly in the function. We’ll show you how. Capitalize Text Using the UPPER Function If you’d like to turn all letters of your text to uppercase (i.e., capitalize your text), specify your text in Excel’s UPPER function as follows. First, in your spreadsheet, select the cell in which you want to display the uppercase text. In the selected cell, type the following function and press Enter. In the function, make sure to replace B3