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.