Excel UPPER Function: How to Make Text All Caps

Formulas & functions · Updated November 18, 2026

Excel’s uppercase text function is UPPER. In Microsoft Excel for Microsoft 365, enter =UPPER(A2) to convert the text in cell A2 to uppercase; the formula returns the converted text in another cell and leaves the original unchanged.

What the UPPER function does

UPPER changes lowercase letters in text to uppercase letters. It preserves the text’s meaning and order, as well as spaces, punctuation, and digits. For example, a name such as Maria Lopez becomes MARIA LOPEZ, while a code such as ab-204 becomes AB-204. The function is useful when a worksheet needs consistent capitalization for names, product codes, labels, or imported text.

The result is a text value, not a change to the cell’s font or number format. UPPER does not edit the source cell: it calculates a converted result elsewhere. That distinction matters when the original spelling needs to remain available, or when the uppercase version is only for display or an export. You can keep both columns, or replace the source values with the results after checking them.

UPPER is a text function, so it does not turn a numeric value into a different number. If a cell contains a number stored as a number, applying UPPER has no letters to change. If a code includes digits and letters, the letters become uppercase and the digits remain as they are.

UPPER syntax and a simple example

The function takes one argument: the text to convert. That argument can be typed text in quotation marks or, more commonly, a cell reference containing text. With the source text in A2 and the result intended for B2, enter this formula in B2:

=UPPER(A2)

If A2 contains quarterly sales, B2 displays QUARTERLY SALES. If A2 contains Order no. ab-204, the result is ORDER NO. AB-204. The formula updates if the text in A2 changes, because B2 recalculates from its reference.

To enter it, select B2, type the formula, and press Enter. In Excel for Microsoft 365 on Windows, the result appears in B2. The same function and formula work in Excel for Mac and Excel for the web; interface details can vary, but the worksheet formula does not.

Convert a whole column

For a list, put the results in a neighboring column rather than overwriting the source immediately. For example, if names are in A2:A100, enter the formula in B2 using the A2 reference, then fill the formula down through B100. Each row will refer to its matching source row: the next row will use A3, then A4, and so on.

Several ways to fill the formula are available in desktop Excel:

  • Drag the small fill handle at the lower-right corner of B2 down the rows you need.
  • Select B2 and the destination cells below it, then use Home > Fill > Down.
  • If the source data is formatted as an Excel table, enter the formula in the first row of the adjacent column. Excel generally fills a calculated-column formula through the table.

Check the first few results and the bottom of the list, especially if the data contains blanks or ends at an irregular row. A formula copied farther than the source list may simply return an empty-looking result for blank cells, but it can also make a worksheet harder to review. For a changing list, an Excel table can make the source and output columns easier to manage as rows are added.

Keep the uppercase results as fixed text

A formula result changes whenever its source changes. If you need a permanent snapshot—for example, to send a cleaned list to another system—copy the result cells and paste their values over the formulas or into a separate destination.

  1. Select the cells containing the UPPER results and copy them.
  2. Select the destination cells, or the same result range if you intend to replace the formulas.
  3. Choose Home > Paste > Paste Values. In desktop Excel, the Paste Values option is also available from the paste menu after copying.
  4. Check several entries, then remove the original source column only if you no longer need it.

On Windows, Ctrl+C copies the selection. On Mac, use Command+C. The ribbon’s Paste Values command avoids relying on a shortcut that may differ by operating system or keyboard configuration. Pasting values removes the formulas from the cells being replaced, so preserve a copy of the workbook or retain the original column if you may need to revise the output later.

Excel for the web also supports formulas and paste values, although the layout of its ribbon can differ from desktop Excel. If a workbook is shared, remember that replacing formulas with values also removes the automatic link to the source text for other people opening it.

What UPPER changes—and what it does not

UPPER changes letter case; it does not clean or standardize every aspect of a text field. It does not trim leading or trailing spaces, remove duplicate spaces, correct spelling, or apply title case. For example, converting jane DOE produces uppercase letters but keeps the spaces. If spacing must be corrected too, handle that as a separate cleanup step and inspect the result.

It also does not modify cell styling. A cell may use a font, color, or number format independently of the text stored in it. Conversely, making the font appear uppercase through a visual convention does not change the underlying value. If another application, lookup, or export needs literal uppercase characters, use a text conversion such as UPPER and then keep the formula or paste its values.

Case conversion can depend on the writing system and language rules supported by the software. For ordinary English names, labels, and codes, the expected behavior is straightforward. For multilingual data, especially names or text with accented or non-Latin characters, review representative results rather than assuming every language has a simple one-to-one uppercase equivalent.

UPPER compared with other ways to change case

Excel has three commonly useful case-conversion functions. They produce different results, so choose based on the format the data actually needs:

  • UPPER converts letters to uppercase, as in maria lopez to MARIA LOPEZ.
  • LOWER converts letters to lowercase, as in MARIA.LOPEZ@EXAMPLE.COM to maria.lopez@example.com.
  • PROPER capitalizes the first letter of each word and makes other letters lowercase, as in mARIA lOPEZ to Maria Lopez.

PROPER is not a reliable substitute for human review of names or titles. It may capitalize words in ways that do not match a person’s preferred spelling, brand styling, or conventions such as internal capitals in a product name. UPPER is more predictable when the requirement is simply “all caps,” but it also cannot decide whether the source text is spelled correctly.

Flash Fill is another option for a one-time transformation: type a few examples in the adjacent column and use Data > Flash Fill, or press Ctrl+E on Windows. Flash Fill infers a pattern and supplies values rather than maintaining a formula linked to the source. On Mac, menu availability and shortcuts can vary by Excel release; use the Data tab if Flash Fill is available. For a repeatable, automatically updating conversion, a formula is usually easier to maintain.

Common problems and practical checks

If the formula appears as text instead of producing a result, check whether the cell is formatted as Text or whether an apostrophe was entered before the equals sign. Change the cell format to General, then re-enter the formula. Merely changing the format may not make an already-entered text string calculate; editing and confirming it again can be necessary.

If Excel shows an error, verify that the formula begins with an equals sign and that the cell reference exists. UPPER needs one argument, so an extra separator or an unmatched parenthesis is not needed. If you copied the formula from a document or web page, replace typographic quotation marks with straight quotation marks when quoting text directly.

If the output looks unchanged, the source may already be uppercase, may contain no letters, or may be a number. Check the actual source value rather than only its displayed formatting. Also confirm that calculation is enabled if results do not update after a source edit; Excel’s calculation setting is found under Formulas > Calculation Options. Automatic calculation is the normal setting for most workbooks, but a workbook can be set to manual calculation.

Before replacing a source column, compare a sample of the original and converted data. This is particularly important for identifiers where leading zeros, spaces, or exact character sequences matter. UPPER itself does not remove digits or spaces, but the broader process of copying, exporting, or changing data types can affect how identifiers are represented.

Frequently Asked Questions

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

Can I make text uppercase without changing the original?
Yes. Put the UPPER formula in another cell or column. The source stays as it was, and the formula result updates when the source changes.

How do I make an entire column uppercase?
Enter a UPPER formula beside the first source entry, then fill it down the output column. For a table, entering the formula in the first data row may fill the calculated column automatically.

Can I change text to uppercase without a formula?
For a one-time conversion, Flash Fill may infer the pattern from examples when it is available. You can also use UPPER and paste the results as values. Excel does not provide a standard worksheet command that simply changes selected cell contents to uppercase while preserving them as editable source values.

Does UPPER work in Excel for Mac and Excel for the web?
Yes. UPPER is a standard Excel worksheet function and works in those versions as well as Excel for Microsoft 365 on Windows. Ribbon placement and keyboard shortcuts can differ, but the formula syntax is the same.

Does UPPER remove spaces or fix spelling?
No. It changes letter case only. Spaces, punctuation, digits, and spelling remain as supplied, so perform any required trimming or proofreading separately.

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.