Excel UPPER Function Not Working? Fix Common Causes

If Excel’s UPPER function is not working, first check that the formula is entered as =UPPER(A2), with the text you want to change in cell A2. UPPER changes lowercase letters in its result to uppercase; when the result looks unchanged or the formula itself appears in the cell, the cause is usually the input, cell formatting, or calculation settings.

What the UPPER function does

UPPER is a text function: it returns text with lowercase letters converted to uppercase. It does not edit the source cell. For example, if A2 contains Northwind Ltd., a formula in B2 that refers to A2 returns NORTHWIND LTD.. The original entry in A2 stays as it was.

UPPER changes letters, not every character. Spaces, punctuation, and digits remain as they are, so Item 42 - blue becomes ITEM 42 - BLUE. A value that contains no lowercase letters may therefore appear unchanged even when the function is working correctly. UPPER also does not remove extra spaces, fix spelling, or capitalize only the first letter of each word.

To try it, enter text in A2 and put this formula in B2:

With the text in A2, enter =UPPER(A2) in B2. If A2 contains Northwind Ltd., B2 displays NORTHWIND LTD..

Check the formula and the cell reference

A simple reference formula is the best first test. Confirm that the formula starts with an equals sign, uses the correct cell address, and has a closing parenthesis. Excel’s function name is UPPER, not “uppercase” or “upper case.” A formula entered without the equals sign is treated as ordinary text.

Also verify that the referenced cell contains the text you mean to convert. If the formula points to a blank cell, a different row, or a cell containing only digits, the result may be blank or look unchanged. Click the result cell and inspect the formula bar to see the actual formula. In a filled-down column, check a few rows: a reference that shifted unexpectedly can make some results appear wrong.

To test the function independently of your data, type a short lowercase word into A2 and use the same formula in B2. If the test works but the original row does not, investigate that row’s contents rather than the function itself.

If Excel displays the formula instead of the result

If you can see =UPPER(A2) in the cell rather than its answer, Excel may be treating the entry as text. Select the cell and look at Home > Number Format. If it is set to Text, change it to General, then re-enter the formula. Changing the format alone may not make an already-entered text string calculate: press F2, then Enter, or edit and confirm the formula again.

Check for a leading apostrophe as well. An entry such as '=UPPER(A2) is deliberately stored as text, so remove the apostrophe if you want Excel to calculate it. Another possibility is that Show Formulas is turned on. On Windows, press Ctrl+` to toggle it; the key is usually beside 1, though keyboard layouts vary. You can also use Formulas > Show Formulas. In Excel for Mac, use Formulas > Show Formulas if the keyboard shortcut differs on your layout.

When Show Formulas is enabled, Excel displays formulas across the worksheet, not just in one cell. Column widths may expand, too. Turn the setting off to return to the normal calculated-result view.

Check calculation settings and stale results

Excel can be set to calculate formulas manually. In that mode, a formula result may not update immediately after you change its source cell. On Windows, open Formulas > Calculation Options and choose Automatic. Excel for Mac has calculation options on the Formulas tab as well; the exact interface can vary by version.

After changing the setting, recalculate if needed. F9 recalculates open workbooks in Excel for Windows; on some laptops you may need Fn+F9. If only one result seems stale, select its formula cell and press Enter to confirm the formula again. UPPER itself is not a volatile function, but it still depends on Excel recalculating after its referenced text changes.

If the result updates only after you press F9, calculation mode is a strong clue. If it never changes, go back to the formula, reference, and cell format checks rather than repeatedly recalculating.

Why the result can look unchanged or incomplete

Several normal outcomes can be mistaken for a failure:

The input is already uppercase. UPPER has nothing visible to change.
The input contains digits or symbols. These characters do not have uppercase forms.
The source is blank. A reference to a blank cell generally produces a blank-looking result.
The result is clipped. A narrow column or neighboring content can make a value hard to read. Widen the column or inspect the formula bar.
The source includes unwanted spaces or characters. UPPER changes letter case but preserves spaces and most other characters.

For instance, west bay becomes WEST BAY ; its leading and trailing spaces remain. If you need to remove ordinary extra spaces as well, use TRIM around the reference. With source text in A2, enter =UPPER(TRIM(A2)) in B2. This returns WEST BAY for the example above. TRIM removes extra standard spaces but does not remove every kind of invisible character.

Handle imported spaces and errors

Data copied from websites, PDFs, or other systems can contain nonbreaking spaces, control characters, or errors. UPPER will not clean these up. A nonbreaking space can look exactly like an ordinary space but resist trimming, while an error in the source cell is passed through to the formula result.

For a common imported-data problem, CHAR(160) represents a nonbreaking space. With imported text in A2, this formula in B2 replaces that character with a regular space, trims extra standard spaces, and converts letters to uppercase:

With imported text in A2, enter =UPPER(TRIM(SUBSTITUTE(A2,CHAR(160)," "))) in B2. If A2 contains North Bay with a nonbreaking space between the words, the result is NORTH BAY.

This handles that specific character, not every possible invisible character. CLEAN can remove certain nonprinting ASCII control characters, but it is not a universal repair for all imported text. If the source displays an error such as #VALUE!, inspect and correct the source or the formula that created it; wrapping it in UPPER will not resolve the underlying error.

Fill the formula down, or replace the original values

For a list, put the formula beside the first item, then copy it down. With source names in A2:A100, enter =UPPER(A2) in B2 and fill down through B100. Excel adjusts the relative reference so the next row uses A3, then A4, and so on. Double-clicking the fill handle can fill adjacent rows when the neighboring data provides a continuous guide; otherwise, drag or copy the formula to the required range.

If you need uppercase text in place of the original entries, UPPER does not have an in-place mode. Keep the formula results in a separate column, check them, then copy the results and use Home > Paste > Paste Values over the original cells if replacing them is appropriate. This removes the formulas and leaves their current displayed text. Keep a copy of the source data first if you may need to restore it.

Do not copy formula results over the source cells while those formulas still refer to those same cells. That can create circular references or overwrite the inputs before you have preserved the results. Using a separate output column avoids that problem.

Choose UPPER, PROPER, LOWER, or another approach

UPPER is right when every letter should be uppercase, such as for standardizing product codes or preparing a list of names for a system that requires uppercase text. It is not the right choice for every case-cleanup task:

Use PROPER when you want the first letter of each word capitalized. It may not format names, acronyms, or brand styling exactly as intended, so review exceptions.
Use LOWER when you want all letters in lowercase, such as for a consistent display or a simplified text comparison.
Use Find and Replace or a controlled manual edit when only specific terms or exceptions should change. These approaches do not automatically apply a case conversion to an entire range.
Use Flash Fill when you provide an example of the desired transformation and want Excel to infer a pattern. Review its output, especially when entries are inconsistent.

For ordinary equality comparisons, Excel’s standard comparison is generally not case-sensitive. That means UPPER is often unnecessary just to compare two text cells. If you specifically need a case-sensitive comparison, use the EXACT function instead of assuming that converting text to uppercase changes how every comparison works.

Frequently Asked Questions

Why does Excel show =UPPER(A2) instead of the answer?
Check whether the cell is formatted as Text, whether the formula has a leading apostrophe, or whether Show Formulas is on. Change a Text-formatted cell to General and re-enter the formula, or turn off Formulas > Show Formulas.

Does UPPER change the original cell?
No. It returns an uppercase result in the formula cell and leaves the source unchanged. To replace the source, copy the results and paste values over the original only after checking and preserving the data.

Why are spaces still in the result?
UPPER changes letter case, not spacing. Use TRIM for ordinary extra spaces; imported nonbreaking spaces may need to be replaced separately with SUBSTITUTE.

Can UPPER capitalize just the first letter of each word?
No. UPPER makes all letters uppercase. PROPER is the built-in function for capitalizing the first letter of each word, though names and acronyms may need manual correction.

Why did my formula not update after I edited the text?
The workbook may use manual calculation. Choose Formulas > Calculation Options > Automatic, then recalculate if necessary. Also confirm that the formula refers to the cell you actually edited.

Does UPPER work in Excel for the web or on Mac?
Yes. UPPER is a standard Excel function. The formula works the same way in Excel for the web and on Mac, though some ribbon labels and keyboard shortcuts can differ from Windows.

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

More in Errors & fixes

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

Spotted an error in this guide? Let us know.