UPPERformula in Google Sheets converts all the letters in a given text string to uppercase. It takes one required argument, the
textto convert. This formula is commonly used to standardize text data or to make it easier to compare text values.
- How to use
- Examples of using
UPPERformula not working?
- Similar formulas to
UPPER formula with the syntax shown below, it has 1 required parameter:
- text (required):
The text string to convert to uppercase. It can be a cell reference or a text string enclosed in double quotes.
ExamplesHere are a few example use cases that explain how to use the
UPPERformula in Google Sheets.
UPPER formula to convert all names in a column to uppercase, making it easier to compare them and avoid duplicates.
Clean up text data
UPPER formula to standardize text data by converting it all to uppercase, making it easier to search for specific words or phrases.
Format text for reports
UPPER formula to format text for reports or other documents where uppercase is preferred for headings or titles.
UPPERnot working? Here are some common mistakes people make when using the
UPPERGoogle Sheets Formula:
Using Numbers Instead of Text
If you accidentally use a number instead of text as the input for the
UPPER formula, you will receive an error. Make sure to always enclose text strings in double quotes.
Not Specifying a Text String
If you forget to specify a text string as the input for the
UPPER formula, you will receive an error. Make sure to always include a text string inside the parentheses.
The following functions are similar to
UPPER or are often used with it in a formula:
LOWERformula converts all letters in a specified text string to lowercase. It takes one required parameter, which is the text string to be converted. This formula is commonly used to standardize text data for easier analysis and comparison.
PROPERformula capitalizes the first letter of each word in a given text string. This formula is commonly used to format names and titles.
The CONCATENATE function in Google Sheets is used to combine text strings from different cells or inputted directly in the formula. It takes one or more text strings as input and returns a single concatenated string. This function is commonly used to combine first and last names, or to merge data from multiple cells into a single cell.
You can learn more about the
UPPER Google Sheets function on Google Support.