Skip to main content

UPPER function


UPPER Function converts all lowercase letters in a text string to uppercase.

If you want to converts all uppercase letters in a text string to lowercase, please use LOWER function.




Text Required. The text you want converted to uppercase. Text can be a reference or text string. UPPER does not change characters in text that are not letters.


The example may be easier to understand if you copy the example data (include header) in the following table, and paste it in cell A1 of a new Excel worksheet. If you need to, you can adjust the column widths to see all the data.

Data Formula Result Description
Excel Bible =UPPER(A2) EXCEL BIBLE Upper case of text string.
ExcelBaby =UPPER(A3) EXCELBABY Upper case of text string.
Excel 2019 =UPPER(A4) EXCEL 2019 Upper case of text string.

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>