🔤 Text Function · beginner
UPPER Function in Google Sheets
Converts text to uppercase.
Syntax
UPPER(text)Returns: text in uppercase.
Excel equivalent: UPPER (identical)
Parameters
| Name | Required | Description |
|---|---|---|
| text | Required | String to convert. |
Examples
Case-insensitive comparison
=UPPER(A2) = UPPER(B2)Compare ignoring case.
Whole column
=ARRAYFORMULA(UPPER(A2:A100))Apply to a column.
When to use an alternative
- LOWER — Lowercase.
- PROPER — Title case.
- EXACT — Case-sensitive comparison.
Common errors and how to fix them
Numbers unchanged
Cause: Only affects text.
Fix: TEXT() first if needed.
Related functions
LOWER
Converts text to lowercase. Used for email normalization and case-insensitive dedup....
TRIM
Removes leading, trailing, and duplicate internal whitespace from a text value. The first cleanup fu...
CONCATENATE
Joins multiple text values into one string. The classic way to combine fields, but TEXTJOIN is usual...
FIND
Returns position of one string in another, case-sensitively....
LEFT
Returns the leftmost N characters of a string. The simplest text-extraction function — useful for pr...
Frequently Asked Questions
Accented chars?
Yes — Unicode case mappings. é → É.
First letter only?
UPPER(LEFT(A2,1)) & LOWER(MID(A2,2,LEN(A2))).