UPPER()
Syntax. UPPER(text)
Definition. The UPPER() function converts text to uppercase.
Arguments
text (required). The text you want to convert to uppercase, which can be a reference or a string.
Background. This function provides a quick and easy method for converting text to uppercase.
You can also use this function to make non–case-sensitive comparisons.
If you pass a numeric value in the text argument, the value is converted to unformatted text. If you refer to this text in numeric calculations, Excel converts the text back to a number value so that you can still use the result for other calculations.
Example. If you want to compare text strings and are not concerned about the comparison being case-sensitive, you can convert the entire text to uppercase ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
