=UPPER(text)
=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.
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.