Google Sheets

UPPER: Google Sheets Formulae Explained

How do you use UPPER in Google Sheets?

There are a few different ways to use UPPER in Google Sheets. One way is to use the UPPER function, which will take a text input and convert it to all uppercase letters. Another way is to use the STRING function with the LOWER function, which will take a text input and convert it to lowercase letters, and then convert the result to all uppercase letters.

What is the syntax of UPPER in Google Sheets?

The syntax of UPPER in Google Sheets is to place the text you want to be uppercase within the parentheses after the UPPER function. For example, if you wanted the text "Hello" to be displayed in all uppercase letters, you would type the following formula into a cell: =UPPER("Hello")

What is an example of how to use UPPER in Google Sheets?

In Google Sheets, you can use the UPPER() function to convert all of the letters in a text string to uppercase. For example, if you enter the text "hello world", the UPPER() function will convert all of the letters to uppercase and return the string "HELLO WORLD".

When should you not use UPPER in Google Sheets?

There are a few occasions when you might not want to use UPPER in Google Sheets. If you're trying to compare two cells and you want to see if they're equal, using UPPER will not work correctly. This is because UPPER will change the text in both cells to uppercase, when you may only want to compare the text in the cells if they're all in the same case. Additionally, if you're working with text that includes special characters, using UPPER may change these characters to uppercase as well, which can potentially change the meaning of the text.

What are some similar formulae to UPPER in Google Sheets?

Some similar formulae to UPPER in Google Sheets are TEXTJOIN(), PROPER(), and LOWER(). TEXTJOIN() is used to join text from multiple cells into a single cell, while PROPER() and LOWER() are used to change the formatting of text to uppercase or lowercase, respectively.

Move beyond 

Google Sheets

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.