UPPER

The UPPER function returns a string in which all letters are uppercase.

This function can be useful when you need to format text, such as names or titles, so that they appear uniform.

Syntax

UPPER(string)

Argument	Description	Permitted values
string	Text string that needs to be uppercase	Text string or reference to a cell containing text

Examples of use

Text conversion

=UPPER("hello, world")

The result: "HELLO, WORLD".

Use with a cell

=UPPER(A1)

If cell A1 contains the word “IrraTioNal,” the function will return “IRRATIONAL”.

Combining with other functions

=UPPER(CONCATENATE("hello, ", B1))

If cell B1 contains “world”, the function will return “HELLO, WORLD.”

Notes

• If the text is already written in capital letters, the UPPER function will not change it.
• The function ignores cell formatting. It simply converts the text to uppercase letters.