UPPER Excel Formula: Capitalize Text in Excel Cells

To make every letter in text uppercase in Excel, use the UPPER function. If the original text is in A2, enter =UPPER(A2) in another cell; for example, “hello world” becomes “HELLO WORLD.” The formula changes letter case in its result, while leaving the original cell unchanged.

What the UPPER function does

UPPER converts lowercase letters in a text value to uppercase. It takes one argument: the text you want to transform. That argument can be a cell reference, a text value, or an expression that produces text. The function does not add spaces or punctuation, and it does not change the meaning of the text.

For example, if A2 contains “Order status: shipped,” and the formula is entered in B2, B2 displays “ORDER STATUS: SHIPPED.” Numbers and punctuation remain as they were. If a cell contains “Room 4-B,” the output is “ROOM 4-B,” not a rewritten or reformatted version of the label.

UPPER is useful when a consistent uppercase appearance is required for names, product codes, headings, categories, or imported data. It is a text function: it does not change a cell’s font setting, apply a visual text effect, or alter the source value in place. The result is produced in the cell containing the formula.

How to use UPPER in Excel

In Excel for Microsoft 365 on Windows, place the formula in a blank cell next to the text you want to convert. With the source value in A2, enter this in B2:

=UPPER(A2)

If A2 contains “north region,” B2 returns “NORTH REGION.” To apply the formula to more rows, select B2 and use the fill handle—the small square at the lower-right corner of the selected cell—to drag down. Excel adjusts the reference for each row, so the next row refers to A3, then A4, and so on.

You can also enter the formula by selecting B2, typing an equals sign and the function, and then selecting A2. Press Enter to calculate it. The formula bar shows the formula when B2 is selected, while the cell itself shows the uppercase result. This distinction matters: the cell contains a formula that refers to A2, not a permanently rewritten copy of A2’s text.

Keep the original text in one column, such as A.
Enter the UPPER formula in the corresponding row of another column, such as B.
Fill the formula down for the remaining rows.
Review the results before replacing or sharing the original data.

The formula works the same way in Excel for Mac and Excel for the web. Ribbon details and keyboard shortcuts can differ between platforms, but the function and formula syntax do not.

Convert a whole column or range

For a conventional worksheet, enter the formula in the first result row and fill it down. With source values in A2:A5, enter this in B2 and copy it through B5:

=UPPER(A2)

If the four source cells contain “east,” “West,” “Central,” and “south,” the corresponding results are “EAST,” “WEST,” “CENTRAL,” and “SOUTH.” Relative references update automatically when the formula is copied down, so each result uses the text from its own row.

In Microsoft 365, a formula can also return results for a range as a dynamic array. With text in A2:A5 and the cells below B2 empty, enter this in B2:

=UPPER(A2:A5)

Excel spills the four converted results down from B2. The cells in the spill area must be clear; otherwise, Excel displays a spill error because it cannot place the full result. This array approach is convenient for a changing list, while filling a single-cell formula down is often easier to understand in a workbook that uses traditional row-by-row formulas.

Excel Tables offer another practical option. If the data is formatted as a table with a column named Name, add a result column and use a structured reference to the current row. With the table’s source column named Name, enter this in the new table column:

=UPPER([@Name])

Excel generally fills a calculated-column formula through the table automatically. Structured references can be easier to maintain than fixed-looking cell addresses when table rows are added, because the reference identifies a column by its header.

UPPER compared with PROPER and LOWER

UPPER is one of Excel’s three familiar case-conversion functions. Choose the one that matches the intended result, rather than assuming that all capitalization means the same thing.

UPPER makes every letter uppercase. With “maria lopez” in A2 and a result formula in B2, enter =UPPER(A2) to return “MARIA LOPEZ.”
LOWER makes every letter lowercase. With “MARIA LOPEZ” in A2 and a result formula in B2, enter =LOWER(A2) to return “maria lopez.”
PROPER capitalizes the first letter of each word and makes the remaining letters lowercase. With “MARIA LOPEZ” in A2 and a result formula in B2, enter =PROPER(A2) to return “Maria Lopez.”

PROPER is not a reliable substitute for editorial name formatting. It may produce “O’neill” where a person or style guide expects “O’Neill,” and it can change intentional capitalization in brand names or abbreviations. Similarly, UPPER will turn an acronym such as “PhD” into “PHD.” If exact name or brand styling matters, review the converted results rather than applying a case function blindly.

Combine UPPER with other text

UPPER can transform a text expression, not just a single cell reference. This is useful for building a standardized label from multiple fields. With a first name in A2 and a department in B2, enter the following in C2:

=UPPER(A2&" - "&B2)

If A2 is “Jordan” and B2 is “support,” the result is “JORDAN – SUPPORT.” The ampersands join the text, and the quoted text supplies the separator. Because UPPER wraps the entire expression, the name, separator text, and department are all passed through the same case conversion; punctuation itself remains unchanged.

You may also want a blank result when the source cell is empty. With possible text in A2 and the formula in B2, enter:

=IF(A2="","",UPPER(A2))

This returns an empty string when A2 is empty, and uppercase text otherwise. Without the IF check, UPPER applied to an empty cell normally displays an empty result too, so the extra condition is not necessary for every sheet. It can still be helpful when you want the logic to be explicit or are combining the result with other formulas.

Common problems and limits

The formula appears as text. If Excel displays the characters of the formula instead of calculating it, check whether the cell is formatted as Text or whether a leading apostrophe was entered. Change the cell format to General, then re-enter the formula. Also check whether Show Formulas is enabled, which displays formulas across the worksheet instead of their results.

The source text has extra spaces. UPPER changes letter case but does not remove leading, trailing, or repeated spaces. If A2 contains “ east ” with spaces around the word, the uppercase result keeps those spaces. If you need to clean ordinary extra spaces as well, with the original text in A2 and the result in B2, use:

=UPPER(TRIM(A2))

TRIM removes leading and trailing spaces and reduces repeated spaces between words to single spaces. It does not remove every kind of whitespace that can appear in imported data, such as some nonbreaking spaces, so unusual copied data may need additional cleanup.

The source cell contains an error. UPPER cannot turn an Excel error such as #N/A into ordinary text; the error generally carries through the calculation. Find and fix the source problem, or decide explicitly how errors should be handled before building a larger formula.

You expected the original cell to change. A formula returns a result elsewhere; it cannot overwrite its own input cell. Keep the formula results in a separate column, or replace the original values with copied results after checking them. This separation also gives you a way to compare the source and converted text before committing a change.

Some characters do not appear to change. Numbers, punctuation, spaces, and characters with no uppercase form stay visually the same. That does not mean the formula failed. UPPER changes letters that have a case distinction; it does not convert a numeric value into a different number or remove symbols.

Keep uppercase results as fixed text

Formula results update when their source text changes. If you need a fixed uppercase copy—for example, to send a static list to another system—copy the result cells and paste their values over a destination range. In Excel for Microsoft 365 on Windows, use Home > Paste > Paste Values. On Mac or the web, the formula is unchanged, but the paste menu or shortcut may be different; choose the Paste Values option available in that version.

Be careful not to paste values directly over the only copy of your source data unless that is intentional. A safer workflow is to retain the original column, create and inspect the uppercase results, then paste values into a separate destination column or a copy of the workbook. Once values replace formulas, they no longer update when the source changes.

If the goal is only to show text in uppercase without changing the stored text, a formula is not the same as a font-formatting choice. Excel does not provide a standard cell font setting that automatically displays arbitrary text in uppercase while preserving its original letter case. A formula result or a deliberate replacement with values is the dependable approach.

When UPPER is useful

Case conversion is most helpful when a consistent format improves scanning, matching, or presentation. Common examples include standardizing short category labels, displaying inventory codes, preparing headings, and cleaning a column before exporting it. Before converting a large dataset, consider whether uppercase is appropriate for every value: sentence text and personal names may be less readable or may lose meaningful capitalization.

Also distinguish case conversion from data validation. Making two labels look alike does not confirm that either one is correct, and changing case does not remove spelling differences. If you are preparing values for a lookup or comparison, decide whether case matters to the operation and whether spaces or other inconsistencies also need attention. UPPER addresses letter case alone.

Frequently Asked Questions

What is the Excel formula to make text uppercase?
Use UPPER with the text or cell reference. If the text is in A2, enter =UPPER(A2) in another cell to return its uppercase form.

Can UPPER change text in the same cell?
No. A formula returns its result in the cell where the formula is entered and cannot overwrite its own source. Use a separate result column, then copy and paste values if you need a fixed replacement.

Does UPPER work on an entire column?
Yes. Fill a formula down beside the source data, or in Microsoft 365 use a range reference that spills results into empty cells. A formula referring to an entire worksheet column may calculate more than needed, so a defined data range or table is usually more practical.

What is the difference between UPPER and PROPER?
UPPER capitalizes every letter, while PROPER capitalizes the first letter of each word and lowercases the rest. PROPER can mishandle names, abbreviations, and brand styling, so check its output when exact capitalization matters.

Why does my UPPER formula show instead of the answer?
The cell may be formatted as Text, the formula may have a leading apostrophe, or Show Formulas may be enabled. Set the cell to General and re-enter the formula, and check the worksheet’s formula display setting.

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.