Check Sheet Logo
Check Sheet

UPPER

The UPPER formula in Google Sheets converts all the letters in a given text string to uppercase. It takes one required argument, the text to convert. This formula is commonly used to standardize text data or to make it easier to compare text values.

Usage

Use the UPPER formula with the syntax shown below, it has 1 required parameter:

=UPPER(text)
Parameters:
  1. text (required):
    The text string to convert to uppercase. It can be a cell reference or a text string enclosed in double quotes.

Examples

Here are a few example use cases that explain how to use the UPPER formula in Google Sheets.

Standardize names

Use the UPPER formula to convert all names in a column to uppercase, making it easier to compare them and avoid duplicates.

Clean up text data

Use the 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

Use the UPPER formula to format text for reports or other documents where uppercase is preferred for headings or titles.

Common Mistakes

UPPER not working? Here are some common mistakes people make when using the UPPER Google 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.

Related Formulas

The following functions are similar to UPPER or are often used with it in a formula:

  • LOWER

    The LOWER formula 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.

  • PROPER

    The PROPER formula capitalizes the first letter of each word in a given text string. This formula is commonly used to format names and titles.

  • CONCATENATE

    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.

Learn More

You can learn more about the UPPER Google Sheets function on Google Support.