UPPER

UPPER(text)

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

textThe 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 value 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("Microsoft Office Add-ins") = MICROSOFT OFFICE ADD-INS
4=UPPER("BE MORE Productive") = BE MORE PRODUCTIVE
5=UPPER("Should't") = SHOULD'T
6=UPPER("123456789") = 123456789
7=UPPER("a1b2c3d4") = A1B2C3D4
8=UPPER("A1B2C3D4") = A1B2C3D4


© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top