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 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


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