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.
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")
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".
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.
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.