UPPER function

UPPER converts any supplied text to all capital letters, returning a string of the same length with every alphabetic character in uppercase.

=UPPER(text)

Generate a UPPER formula

Describe what you need. The generator will reach for UPPER where UPPER is the right tool, and tell you when it is not.

How to get a better answer
  • Name your columns by letter and by header: "column F (Net Value)" beats "the amount column".
  • State every condition, including the negatives — "not cancelled" changes the formula's shape.
  • Say where the data starts if it is not row 1, and whether it will grow.
  • Check the settings above match your spreadsheet: the wrong argument separator is a syntax error on your machine.

Arguments

How UPPER reads its arguments
textrequiredUPPER →
ArgumentRequiredDescription
textRequiredThe text, cell reference, or range to change; non-text values (numbers, logicals) cause #VALUE! or propagate the original error.

Returns

It returns a single-cell text string or, when given a range, an array of text strings of identical dimensions.

Availability

Excel: All · Google Sheets: Supported

Worked examples

1. Standardize a vehicle name

VehicleOdometerService DateCostGarage
Truck A452002023-04-15350North Garage
=UPPER(A2)

Result: TRUCK A

A2 contains the vehicle name "Truck A". The UPPER function examines each character and converts the alphabetic ones to their uppercase equivalents, leaving numbers and punctuation unchanged. The resulting string "TRUCK A" is returned as a plain text value.

2. Uppercase all garage names at once

VehicleOdometerService DateCostGarage
Truck A452002023-04-15350North Garage
Van B301202023-05-03210South Garage
Car C178902023-06-21145East Garage
=UPPER(E2:E4)

Result: NORTH GARAGESOUTH GARAGEEAST GARAGE

The range E2:E4 holds three garage names written in mixed case. By passing the whole range to UPPER, the function returns a dynamic array where each element is the uppercase version of the corresponding input cell. The array spills into adjacent cells, producing "NORTH GARAGE", "SOUTH GARAGE" and "EAST GARAGE".

3. Create an all-caps identifier from vehicle and garage

VehicleOdometerService DateCostGarage
Truck A452002023-04-15350North Garage
=UPPER(A2 & "_" & E2)

Result: TRUCK A_NORTH GARAGE

First the ampersand operator concatenates the vehicle name, an underscore, and the garage name, producing "Truck A_North Garage". Wrapping that result in UPPER forces every alphabetic character to uppercase, yielding the identifier "TRUCK A_NORTH GARAGE" which can be used for labeling or lookup purposes.

Common errors

Which UPPER error are you seeing?
UPPER returned an error#VALUE!
Wrap the value with TEXT() to convert it to a string first, or ensure the referenced cell contains actual text.
#N/A
Use IFERROR or IFNA around the lookup to supply a default text, then apply UPPER to the safe result.
#REF!
Correct the cell address or restore the missing range so that UPPER receives a valid reference.
ErrorWhy it happensHow to fix it
#VALUE!The argument supplied to UPPER is a numeric value or a logical, which cannot be coerced to text for case conversion.Wrap the value with TEXT() to convert it to a string first, or ensure the referenced cell contains actual text.
#N/AThe referenced cell contains a #N/A error, commonly from a failing lookup; UPPER propagates that error unchanged.Use IFERROR or IFNA around the lookup to supply a default text, then apply UPPER to the safe result.
#REF!A cell reference in the UPPER argument points to a deleted or invalid range, causing a reference error.Correct the cell address or restore the missing range so that UPPER receives a valid reference.

Tips and when to use something else

  • UPPER works on entire ranges; in Excel 365 or Google Sheets the result will spill automatically into adjacent cells.
  • If you need only the first letter of each word capitalized, use PROPER instead of UPPER.
  • Combine UPPER with TEXTJOIN or CONCAT to build all-caps labels from multiple columns.
  • When dealing with numbers that must appear in a string, apply TEXT first, then wrap the result in UPPER.

Related functions

LOWERLOWER converts any supplied text to all-lowercase characters, returning a string or an array of strings matching the input shape.PROPERPROPER converts a text string to title case, capitalising the first letter of each word while making all other letters lower-case.CONCATCONCAT joins two or more text strings into one continuous string, automatically coercing numbers and dates to text without a delimiter.TEXTJOINTEXTJOIN merges multiple text strings or ranges into one string, using a chosen delimiter and optional ignoring of empty cells.LEFTLEFT returns the leftmost characters from a text string, optionally limited by a specified number of characters.

Frequently asked questions

How can I convert an entire column of vehicle names to uppercase in Google Sheets?
Place =UPPER(A2:A) in a blank column; Google Sheets will return a dynamic array of uppercase names that automatically expands as you add more rows. Ensure the column you target contains only text to avoid #VALUE! errors.
Will UPPER change dates formatted as text?
If a date is stored as a true date value, UPPER will first coerce it to its underlying serial number, which is numeric, and then return #VALUE!. Convert the date to a text string with TEXT() before applying UPPER if you need the textual representation in uppercase.
Why does UPPER return #VALUE! when I reference a cell that looks like a number?
UPPER expects a text string. When the referenced cell contains a pure number (e.g., 12345), the function cannot perform case conversion and therefore raises #VALUE!. Wrap the number with TEXT() or prepend an empty string (""&A2) to force a text type.
Can I use UPPER inside an array formula to process non-contiguous cells?
Yes. In Excel you can write =UPPER((A2,A4,A6)) using the CHOOSE function or a range that includes blanks; the result will be an array of uppercase strings for each specified cell. In Google Sheets, =UPPER({A2;A4;A6}) achieves the same effect.

Need a different formula?

The full generator is not scoped to one function — describe any spreadsheet problem and it will pick.

Open the formula generator

Reviewed 2026-09-17