Excel UPPER Function: Convert Text to Uppercase

Formulas & functions · Updated November 18, 2026

In Excel, use the UPPER function to convert text to uppercase: with the text to change in cell A2, enter =UPPER(A2) in another cell. For example, if A2 contains Northwind Ltd, the formula returns NORTHWIND LTD; it changes letter case without changing the underlying source cell.

What the UPPER function does

UPPER changes lowercase letters in a text value to uppercase. It leaves characters that are not letters, such as spaces, punctuation, and digits, as they are. This makes it useful for applying a consistent visual style to names, codes, headings, and imported text.

With the source value Northwind Ltd in A2, the result of =UPPER(A2) is NORTHWIND LTD. With a product code such as ab-204x in A2, it returns AB-204X: the hyphen and digits remain unchanged. The function works on the text supplied to it, which can be typed directly into the formula or referenced from another cell.

UPPER does not edit the original cell. It returns a converted result wherever the formula is entered, so the original and uppercase versions can sit side by side. That is useful when you need to retain imported data for comparison or auditing while preparing a standardized version for a report or export.

Syntax and basic use

The function has one argument: UPPER(text). The argument can be a cell reference or a text value. In a worksheet, formulas begin with an equals sign. If the source is A2, enter =UPPER(A2) in B2. Excel displays the result in B2, and the formula bar shows the formula when B2 is selected.

To convert a list, put the formula beside the first item and fill it down. For example, with names in A2:A20, enter =UPPER(A2) in B2, then copy or fill the formula through B20. The relative reference changes as it is filled: the formula in B3 refers to A3, and the formula in B20 refers to A20.

  1. Insert a blank column beside the text you want to convert, if you need to preserve the source.
  2. Enter the UPPER formula in the first result cell, using a reference to the first source cell.
  3. Press Enter and check that the displayed result is as expected.
  4. Fill the formula down the remaining rows. You can drag the fill handle at the lower-right corner of the selected cell, or copy and paste it.

In Excel for Microsoft 365 on Windows, Ctrl+C and Ctrl+V copy and paste. On Mac, use Command+C and Command+V. The formula itself is the same in Excel for Mac and Excel for the web; the main difference is the operating system’s keyboard shortcuts and, in some cases, the ribbon layout.

Convert several cells and combine text

In current Microsoft 365 Excel, you can also enter a formula that refers to a range and let the results spill into adjacent cells. With source text in A2:A5 and an empty output area starting at B2, enter =UPPER(A2:A5) in B2. The results can spill down B2:B5. Make sure the cells in the spill area are empty; existing content can prevent the results from appearing and produce a spill error. If you need a formula that works in older Excel versions too, fill a single-cell formula down the column instead.

UPPER can also convert text that you assemble from multiple cells. With a first name in A2 and a surname in B2, enter =UPPER(A2&" "&B2) in C2 to join them with a space and return the combined name in uppercase. The ampersand joins the pieces; the quoted space supplies the separator. This can be handy for a standardized display field, but keep the original columns if you may later need the names separately.

For a fixed label, you can give UPPER a text value directly. For example, =UPPER("pending review") returns PENDING REVIEW. Direct text arguments must be enclosed in straight double quotation marks in a formula. If you want to uppercase a value that changes, refer to a cell instead of typing the text into the formula.

UPPER changes text, not cell formatting

A common misconception is that UPPER is a formatting command. It is not. It returns a new text result with capital letters; it does not change the font, color, number format, or contents of the source cell. If A2 contains mixed-case text, applying a font effect or changing the cell’s number format will not perform the same operation as =UPPER(A2).

Because the output is a formula, it updates when the source changes. If A2 changes from Northwind Ltd to Northwind Group, B2 recalculates to NORTHWIND GROUP. If you need a permanent uppercase result rather than a live formula, copy the results and paste values over a separate destination. In Excel for Microsoft 365 on Windows, use Copy, then Home > Paste > Paste Values. Check the destination before removing the original data; overwriting source cells with formulas that refer to those same cells can cause circular references or destroy the values you meant to keep.

UPPER also is not a substitute for number formatting. If a cell contains an amount, a date, or another numeric value, use the appropriate number format to control how it is displayed. If a date must become uppercase text, first turn it into a text representation. With a real date in A2, enter =UPPER(TEXT(A2,"mmmm d, yyyy")) in B2. For a date of November 2, 2026, the result is NOVEMBER 2, 2026. The TEXT format code determines the date wording, and displayed date names can depend on the workbook’s regional settings.

UPPER, LOWER, and PROPER compared

Excel has three familiar functions for changing letter case. Choose according to the result you need rather than expecting one function to recognize names or grammar:

  • UPPER makes letters uppercase. With text in A2, =UPPER(A2) turns northwind ltd into NORTHWIND LTD.
  • LOWER makes letters lowercase. With text in A2, =LOWER(A2) turns NORTHWIND LTD into northwind ltd.
  • PROPER capitalizes the first letter of each word and generally makes the other letters lowercase. With text in A2, =PROPER(A2) turns NORTHWIND LTD into Northwind Ltd.

PROPER can be useful for ordinary title-style names, but it is not a reliable language-aware editor. It may capitalize parts of words that should stay lowercase and may not preserve established capitalization in brand names, initials, or specialist terms. For example, a product name containing internal capitals may not come out as intended. Review the results when exact spelling matters. UPPER is more predictable when the requirement is simply that every letter be uppercase.

Excel’s ordinary text comparisons are generally not case-sensitive, so changing text to uppercase is not usually necessary just to make a basic match work. However, consistent case can make reports easier to scan or meet a system’s import requirements. If a task specifically requires comparing case as well as characters, use a case-sensitive comparison method rather than assuming UPPER alone establishes whether two original values differed only by case.

Common problems and ways to handle them

If the formula appears in the cell instead of a converted result, first check that the cell is not formatted as Text and that the formula begins with an equals sign. In Microsoft 365 for Windows, you can change the cell format from Home > Number Format to General, then re-enter the formula. Also check that Show Formulas is not enabled, since that worksheet view displays formulas in cells instead of their calculated results.

If the formula returns an error or an unexpected result, check the reference and the source value. UPPER does not remove leading or trailing spaces, line breaks, or other unwanted characters; it changes letter case. If your goal is to clean imported text, inspect those characters separately and use an appropriate cleanup process rather than expecting UPPER to fix them.

  • The output looks unchanged: the source may already be uppercase, contain no letters, or contain only numbers and punctuation.
  • Only one row changed: the formula may not have been filled down. Copy it to the remaining rows or use the fill handle.
  • A spill formula is blocked: clear cells in the intended output range, or use a formula in each row and fill it down.
  • The result must replace the source: create and check the converted values in a separate column, then paste values where needed. Keep a backup if the original text matters.

For a case-sensitive comparison, an explicit comparison can help. With the two values to compare in A2 and B2, enter =EXACT(A2,B2) in C2; it returns TRUE only when the text matches with the same capitalization and characters. This is different from UPPER: EXACT tests whether the original values match, while UPPER creates an uppercase version.

When UPPER is useful—and when it is not

UPPER is a good fit for standardized identifiers, inventory codes, abbreviations, or labels when the required convention is uppercase. It is also useful for preparing text for a report, creating a visible normalized column, and converting a selection before data is sent to another system that expects capital letters.

It is less appropriate when capitalization carries meaning or when the desired style is sentence case, title case, or a carefully branded spelling. It will turn an entire sentence into uppercase, for example, rather than deciding which words deserve capitals. It also does not validate data: converting a mistyped code to uppercase does not make the code correct. For data entry consistency, pair conversion with checks against the actual list of allowed values or rules for the destination system.

In short, use UPPER when the requested output is text with all its letters capitalized. Use a number format for numeric display, PROPER for a first-letter-per-word style when its limitations are acceptable, and a separate comparison or validation method when you need to test the data rather than change its appearance.

Frequently Asked Questions

What is the Excel formula for uppercase?
Use =UPPER(A2) when the text you want to convert is in A2. Replace A2 with the reference to your own source cell.

Can UPPER change the original cell?
No. The formula returns the uppercase result in the cell where you enter it. To replace a source value, create the result separately, copy it, and paste values into the intended destination.

How do I make an entire column uppercase?
Enter a UPPER formula beside the first source value, then fill it down the rows you need. In Microsoft 365, a range-reference formula can spill results into empty cells, but a filled-down formula is a straightforward option across more Excel versions.

Does UPPER remove spaces or punctuation?
No. It changes letter case and leaves spaces, punctuation, and digits unchanged. Use a separate text-cleaning method if you need to remove unwanted characters or extra spaces.

What is the difference between UPPER and PROPER?
UPPER capitalizes every letter. PROPER capitalizes the first letter of each word and generally makes the rest lowercase, so it produces a different style and may need review for names or brands.

Does Excel have a built-in button to change case?
Excel does not provide Word’s change-case command as a standard worksheet button. A formula such as UPPER is the usual way to produce uppercase text in a worksheet.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.