UPPER

Formulas / UPPER
Convert text to uppercase.
=UPPER(text)
  • text - required, the text to convert to uppercase

Examples

  • =UPPER("Apple")

    The function is used to convert text to uppercase. In this example, the text "Apple" is converted to "APPLE". This function is useful when data needs to be uniform, such as when comparing text strings.

  • =UPPER("pear")

    The function is used to convert text to uppercase. In this example, the text "pear" is converted to "PEAR". This function is useful when data needs to be uniform, such as when comparing text strings.

  • =UPPER("xyy-020-kwp")

    The function is used to convert text to uppercase. In this example, the text "xyy-020-kwp" is converted to "XYY-020-KWP". This function is useful when data needs to be uniform, such as when comparing text strings.

  • =UPPER(A1)

    The function is used to convert cell contents to uppercase. In this example, the cell contents "44373" is converted to "44373". This function is useful when data needs to be uniform, such as when comparing text strings.

Summary

The UPPER function is used to convert text to uppercase by taking a required text argument. It can be used to quickly and easily change the case of any text.

  • The UPPER function takes one argument, a text string which can be a text value or a cell reference.
  • The UPPER function can be used in conjunction with the TEXT function to convert numbers to text in upper case letters.


Frequently Asked Questions

What is the UPPER function?
The UPPER function is a function in Sourcetable which converts text to uppercase.
What does the UPPER function do?
The UPPER function converts text into all uppercase characters.
What is the required argument for the UPPER function?
The argument required for the UPPER function is a text argument.
What is the syntax for the UPPER function?
The syntax for the UPPER function is as follows: UPPER(text).
What type of data should be used in the text argument?
The text argument should be a string of text.
What happens if the text argument is not specified?
If the text argument is not specified, the UPPER function will return an error.
What is the result of the UPPER function?
The result of the UPPER function is the text argument converted to all uppercase characters.
Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV