Quick view of Excel UPPER Function
Explanation: In the above table, Excel UPPER function is applied to the data and the results are from D7 to D10. The formula can be seen in the E column.
Excel UPPER Function
The Excel UPPER function helps us to capitalize the whole text of the selected cell. However, it will not affect numbers and punctuations.
Purpose (When to use UPPER Function)
The UPPER function is used to convert text to all capital letters (Upper Case) of any given word. This can be used especially for headings or for any analysis.
Return value (Result)
This function helps to convert the text to capital letters.
Syntax (Rules to use UPPER Function)
Arguments (Parts of Syntax)
text – The text that needs to be converted to UPPER Case.
To make the text UPPER of “successful year”
=UPPER(“successful year”) makes “SUCCESSFUL YEAR”
To make the text UPPER of “happy Birthday”
=UPPER(“happy Birthday”) makes “HAPPY BIRTHDAY”
To make the text UPPER “Happy new year”
=UPPER(“Happy new year”) make “HAPPY NEW YEAR”
To make the text UPPER “welcome to the party”
=UPPER(“welcome to the party”) make “WELCOME TO THE PARTY”