UPPER(text)

Returns the text string with all the characters converted to upper case.


textThe text string you want to convert to uppercase.

* The "text" can be a cell reference or a text string.
* Any characters that are not text will not be altered.
* 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.
* For the Microsoft documentation refer to support.office.com.

 A
1=UPPER("some text") = SOME TEXT
2=UPPER("Better Solutions") = BETTER SOLUTIONS
3=UPPER("BE MORE Productive") = BE MORE PRODUCTIVE
4=UPPER("123456789") = 123456789
5=UPPER("a1b2c3d4") = A1B2C3D4


© 2017 Better Solutions Limited. All Rights Reserved. © 2017 Better Solutions Limited

Top