Quick Navigation

UPPER Function

Excel 2007+

Summary

The Excel UPPER function converts all lowercase letters in a text string to uppercase. It's perfect for standardizing text formatting, creating consistent data entry, and preparing text for comparisons or lookups that require case uniformity.

Syntax

UPPER(text)

Parameters

Parameter	Type	Required	Description
text	`Text`	Yes	The text string or cell reference containing the text to convert to uppercase letters

Using the UPPER Function

UPPER is commonly used for data normalization, creating uniform text displays, and ensuring case-insensitive matching in lookups. It transforms mixed-case or lowercase text into full uppercase without affecting non-letter characters.

Common UPPER Examples

Basic Text Conversion

=UPPER("hello world")

Converts entire text string to uppercase

Cell Reference Usage

=UPPER(A2)

Converts text in cell A2 to uppercase

Mixed Case Normalization

=UPPER("Total Sales")

Returns "TOTAL SALES" for consistent headers

Frequently Asked Questions

No, UPPER only converts letters to uppercase. Numbers, spaces, and symbols remain unchanged.

Yes, it properly converts accented characters and other Unicode letters to their uppercase equivalents.

Common Errors and Solutions

#VALUE! error

Cause: text argument is not valid text

Solution: Ensure the reference contains text or wrap with TEXT function

Notes

Non-letter characters (numbers, symbols, spaces) remain unchanged
Works with formulas that return text
Useful in combination with LEFT, RIGHT, MID functions
Perfect for preparing data for VLOOKUP or MATCH functions

Compatibility

Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365

Not available in:

Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+