How to Use the UPPER Function in Excel
Introduction
In both Excel and Google Sheets, the UPPER function transforms all the letters in a given text string to uppercase. This function is particularly useful for standardizing text formats across your spreadsheet or enhancing the visual impact of the text.
Syntax
The syntax for the UPPER function is identical in Excel and Google Sheets:
=UPPER(text)text– The text or cell reference that contains the text you wish to convert to uppercase.
Examples
Example 1: Basic Usage
Suppose cell A1 contains the text “hello, world”. To convert this text to uppercase in cell B1, you would use the UPPER function:
| A | B |
|---|---|
| hello, world | =UPPER(A1) |
After inputting the formula in cell B1, it will display “HELLO, WORLD”.
Example 2: Applying UPPER to Text Strings
The UPPER function can also be applied directly to hardcoded text strings. For instance:
=UPPER("convert me")This expression returns “CONVERT ME”.
Example 3: Combining UPPER with Other Functions
The UPPER function can be combined with other functions to perform more complex text manipulations. For example, using UPPER with CONCATENATE allows you to merge and capitalize several text strings:
=UPPER(CONCATENATE("hello ", "world"))This formula will yield “HELLO WORLD”.
Conclusion
The UPPER function is a simple yet effective tool in Excel and Google Sheets for converting text to uppercase. By adhering to the syntax and examples provided here, you can leverage the UPPER function to efficiently manage and format text data in your spreadsheets.
More information: https://support.microsoft.com/en-us/office/upper-function-c11f29b3-d1a3-4537-8df6-04d0049963d6