If you want to change the text case from lowercase to uppercase in Microsoft Excel, then this guide shows you five ways to do it.

Use Upper function to convert text into uppercase in Excel Enter lowercase text into the cell or cells. Type into the cell where you want to place the result, =UPPER (A2).

To use the custom list, simply enter the letter a or A and use the fill handle to complete the alphabetic list. Excel is smart enough to fill in lower or uppercase, accordingly.