October 20, 2021

UPPER function in Excel

The UPPER function converts the lower case texts to upper case in Excel.

  • text: This is the string in which you want to convert lower case characters to upper case.

Below is the example of UPPER function applied on the strings in cell A2, A3 & A4 to convert all the lower case characters to upper case in cell B2, B3 & B4 respectively.


  1. The UPPER function only affects the lowercase characters of the string. Any character other than the lowercase text is left unchanged.
  2. Numbers, special characters & punctuations are not changed by the UPPER function.
  3. If you use a null character (or refer to an empty cell), it will return a null character.

Check here to learn the UPPER function in Google Sheet.

Leave a Reply

Your email address will not be published. Required fields are marked *