How to use Excel UPPER function

Quick view of Excel UPPER Function

How to use Excel Upper Function
How to use 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)

=UPPER (text)

Arguments (Parts of Syntax)

text – The text that needs to be converted to UPPER Case.

Explanations:-
How to use Excel Upper Function
How to use Excel Upper Function

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”

Contact to us