December 3, 2020

UPPER function in Google Sheet

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

=UPPER(text)
  • 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.

Note:

  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 UPPER function in Excel.

Leave a Reply

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