UPPER Function
Makes every letter uppercase.
Syntax
Parameters
| Parameter | Description | Required |
|---|---|---|
| text | The text or cell reference to convert; can be a literal string in quotes or a cell. | Required |
Basic Example
Uppercase a word
=UPPER("hello")All lowercase letters are converted to uppercase.
Advanced Examples
Example 1: Normalize user input
Cell A1 contains "Mr. smith"Standardize a name prefix
=UPPER(A1)Example 2: Combine with other text
Build an uppercase label from a cellUppercase within a concatenation
=UPPER("id-" & A1)How UPPER Works
UPPER scans each character of the input; ASCII and Unicode lowercase letters are mapped to their uppercase equivalents while every other character (digits, punctuation, spaces) passes through unchanged.
Important Notes & Limitations
Does not change non-letter characters.
Case conversion follows the system's locale rules and may not cover every Unicode casing edge case.
Only affects a single text value; use with arrays or helper columns for ranges.
Common Errors & Fixes
#VALUE! errorPassing a non-text argument in strict contexts.Fix: Ensure the argument is text or wrap it with TEXT().
Download Practice File
UPPER
upperPractice UPPER with Real Data
Download a sample CSV file with pre-populated data and practice exercises for the UPPER function. Works in both Excel and Google Sheets.
File format: CSV (comma-separated values) - opens in Excel, Google Sheets, and all spreadsheet apps