UPPER

UPPER(text)

Returns the text string with all the characters converted to uppercase.

text

The text string you want to convert to uppercase.

REMARKS

* The "text" can be a cell reference or a text string.
* Any characters that are not text will not be altered.
* Any characters that are numbers will not be altered.
* Any characters that are symbols or special characters will not be altered.
* You can use the ISTEXT function to return the boolean True or False depending if the value is text.
* You can use the LOWER function to return a text string with all the characters converted to lowercase.
* You can use the PROPER function to return a text string with the first letter of every word as a capital.
* The equivalent VBA function is VBA.UCASE
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A
1	=UPPER("Better Solutions") = BETTER SOLUTIONS
2	=UPPER("better SOLUTIONS") = BETTER SOLUTIONS
3	=UPPER("better SOLUTIONS") = "BETTER SOLUTIONS"
4	=UPPER("Microsoft Office Add, ins") = MICROSOFT OFFICE ADD-INS
5	=UPPER("BE MORE Productive") = BE MORE PRODUCTIVE
6	=UPPER("Should't") = SHOULD'T
7	=UPPER("123456789") = 123456789
8	=UPPER("a1b2c3d4") = A1B2C3D4
9	=UPPER("A1B2C3D4") = A1B2C3D4