Description
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.
Syntax
UPPER(text)Parameters
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.
Examples
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. |