How to use UPPER Function in Excel

The UPPER function to convert a normal text into upper case text.

In simple words, it converts a normal text case into a text in which all the letters are in upper case. For example, “excelchamps” will be converted into “EXCELCHAMPS”.



  1. text A text string which you want to convert into upper case.


As I said, in an upper case text we have all the letters in capital form.

Compare Excel UPPER-Function With Other Cases

In the below example, we have used the upper function to convert name text to capital letters from the text in which characters are in different cases.

Use Excel UPPER Function To Convert Lower Case Name Into Upper Case


Sample File