Excel Text All Caps? How to Change Letter Case

How-to basics · Updated November 18, 2026

Yes. In Excel for Microsoft 365, use the UPPER function to turn text into all capital letters: with the text in cell A2, enter =UPPER(A2) in another cell. The result is uppercase text; the original cell is not changed unless you replace it with the result.

What “all caps” means in Excel

Excel stores the text you type in a cell as data. Changing its capitalization is different from changing its font, color, or number format: Excel does not provide a general-purpose “Change Case” button on the Home tab like Word does. To change letters from lowercase or mixed case to uppercase, use a formula, Flash Fill, or a data-transformation tool.

That distinction matters when a workbook feeds another process. A cell that merely looks uppercase may not contain uppercase letters, while a cell transformed with UPPER does. For instance, a heading displayed in capitals using a font or an image would not necessarily give another formula uppercase text to work with. UPPER changes the text value itself in its result cell.

Uppercasing affects letters, not the whole contents indiscriminately. Numbers, spaces, punctuation, and other nonletter characters remain as they are. Thus, “North-park 42” becomes “NORTH-PARK 42”; the hyphen, space, and digits are preserved.

Use UPPER to capitalize text

For a single cell, select an empty destination cell and enter the formula. With the original text in A2, enter =UPPER(A2) in B2. If A2 contains “Excel text all caps?”, B2 returns “EXCEL TEXT ALL CAPS?” The source cell remains unchanged, so you can compare the original and converted text before deciding what to keep.

For a column, fill the formula down. With original entries in A2:A100 and B2 as the first output cell, enter =UPPER(A2) in B2, then use the fill handle to copy it through B100. Excel adjusts the reference for each row, so the formula in B3 refers to A3, the one in B4 refers to A4, and so on. Double-clicking the fill handle can fill down alongside a neighboring column of continuous data.

If your data is an Excel table, entering the formula in the first row of a new table column generally fills the calculated column automatically. Give the output column a useful heading such as “Uppercase name.” This keeps the transformed result distinct from the original and makes later sorting, filtering, and review easier.

In Microsoft 365, UPPER can also work with a range as a dynamic array. With source text in A2:A5 and an empty output area beginning at B2, enter =UPPER(A2:A5) in B2. The uppercase results spill into the cells below. Make sure the spill area is empty; otherwise Excel reports a #SPILL! error. The single-cell formula filled down is often more practical when the output needs to be edited row by row.

Replace the original text with uppercase values

A formula produces a result in a different cell; it does not overwrite its input. If the workbook needs fixed uppercase text rather than formulas, convert the results to values after checking them. Keep the source column until you are sure the conversion is correct, especially when the data is important or difficult to recreate.

  1. Put the UPPER formula in a helper column and fill it down.
  2. Review several results, including entries with punctuation, accents, spaces, or numbers.
  3. Copy the converted cells.
  4. Select the destination cells, then choose Home > Paste > Paste Values. This replaces formulas with their displayed text values.
  5. Remove the old source column only after confirming the new values are in the intended location.

You can paste the values over the original cells, but take care not to copy a formula and paste it back into its own source range as an ordinary paste. That can create incorrect references or overwrite data. Using a separate helper column first makes the operation easier to inspect and undo. For a workbook you may need to update later, retaining the original column or keeping the formula may be more useful than converting everything permanently.

UPPER, LOWER, and PROPER compared

Excel provides three familiar case-conversion functions. UPPER makes letters uppercase; LOWER makes them lowercase; and PROPER capitalizes the first letter of each word while converting other letters to lowercase. They return transformed text in a result cell and leave the source cell alone.

With the text in A2, enter =LOWER(A2) in B2 to make it lowercase. For example, “North PARK” returns “north park.” This can be useful when a system expects a consistent lowercase format, though whether that is appropriate depends on the data and the receiving system.

With the text in A2, enter =PROPER(A2) in B2 to apply title-style capitalization. “north park” returns “North Park.” PROPER is not a reliable way to format every person’s name, brand, abbreviation, or official title: it may turn “NASA” into “Nasa,” and it cannot know that a particular word should remain lowercase or have unusual capitalization. Check names and specialized terms rather than assuming the result is correct.

Choose the function based on the required output, not simply on which result looks neat. If a mailing list needs uppercase country codes but normal capitalization for people’s names, use different treatments for those columns. Standardization is helpful only when it preserves the distinctions readers and downstream systems need.

Use Flash Fill for a one-time conversion

Flash Fill can recognize a pattern from an example and fill the rest of a column without leaving formulas. Put an uppercase example beside the first source entry, then use Data > Flash Fill. In Windows desktop Excel, Ctrl+E is the shortcut. For example, if A2 contains “morgan lee,” type “MORGAN LEE” in B2 and run Flash Fill for the remaining rows.

Flash Fill is convenient for a one-off cleanup, but it is not the same as a formula tied to the source. If the source text changes later, a filled result does not automatically recalculate. Review the generated entries, especially if the data contains inconsistent spacing, multiple names, abbreviations, or varied formats. If you want the output to update when source values change, use UPPER instead.

Convert text during a Power Query import

Power Query is useful when you repeatedly import or refresh a dataset and want the same case transformation each time. In Excel for Microsoft 365 on Windows, open the query in Power Query Editor, select the text column, and choose Transform > Format > UPPERCASE. Then use Close & Load to return the transformed data to Excel. The exact surrounding import steps depend on whether the source is a file, table, or another connection.

A Power Query transformation is applied as part of the query steps. When you refresh the query, Excel reruns those steps on the incoming data, which can be more dependable than manually converting a newly imported column every time. It does not mean that cells in the original source file have been edited; the uppercase version is the query output loaded into the workbook.

Power Query is more setup than a formula for a handful of cells. It becomes useful when the task is part of a recurring import, when several cleanup steps need to be repeated, or when users should refresh a prepared result rather than reapply a manual procedure. If the Transform tab or options differ in another Excel edition, check the available Power Query features for that edition.

Common problems and misconceptions

  • The original cell did not change. That is expected: a formula returns its answer in the cell containing the formula. Replace the source with pasted values only if that is your intended final result.
  • The result says #SPILL!. This can happen when a range-based formula has cells occupied in the area where its results need to appear. Clear the blocking cells or use a single-cell formula and fill it down.
  • Uppercase text looks the same. If the input is already uppercase, or contains no letters, UPPER may return text that appears unchanged. It does not add capital letters to numbers or punctuation.
  • Sorting or matching did not change. Excel’s ordinary text comparisons and many lookup situations are not made case-sensitive merely by changing capitalization. Uppercase can create a consistent appearance, but it is not a general way to make comparisons case-sensitive. Use a case-sensitive method when that distinction is essential.
  • PROPER changed an abbreviation. PROPER follows a broad word-capitalization pattern, not a dictionary of brands, acronyms, or personal preferences. Review those cases manually or use a controlled correction list.

Also consider whether capitalization is part of the data standard. Uppercase is common for identifiers, codes, and some labels, but converting full names or addresses can reduce readability or conflict with the format expected by another application. If the text will be exported, verify the receiving system’s requirements before replacing the source.

Which method should you choose?

For a small range that should stay linked to its source, use UPPER. It is visible, easy to audit, and updates when the referenced value changes. For a quick, static cleanup, Flash Fill can be faster, provided you check its output. For a recurring import, Power Query can preserve the transformation as a refreshable step. Each approach changes or produces text differently, so decide whether you need a live formula, a one-time result, or a repeatable data-preparation process.

When choosing, consider these practical factors:

  • Will the source change? A formula recalculates from its reference; pasted values and Flash Fill results do not.
  • Will you repeat the import? A saved Power Query transformation can be reapplied during refresh.
  • Must the original be preserved? Use a helper column or duplicate the data before replacing anything.
  • Does exact capitalization matter? Inspect names, acronyms, product labels, and codes; automated case functions cannot infer every preferred spelling.

Frequently Asked Questions

How do I make text all caps in Excel?
With the text in A2, enter =UPPER(A2) in another cell. Fill the formula down for more rows, or use Flash Fill for a one-time conversion.

Can I change text to uppercase without a formula?
Yes. Enter an uppercase example in a neighboring cell and use Data > Flash Fill, or transform the column with Power Query. These options are useful when you do not want a formula in the final output.

How do I make the uppercase result permanent?
Copy the formula results, then choose Home > Paste > Paste Values. The cells contain text values rather than formulas afterward. Keep a copy of the original data if you may need it.

Does Excel have a Change Case button like Word?
Excel does not have Word’s general Change Case command on the Home tab. Use functions such as UPPER, LOWER, and PROPER, or use a pattern-based or data-transformation method.

Can I make only some letters uppercase?
UPPER changes all letters in the referenced text. For a specific mix of uppercase and lowercase characters, edit the text manually or construct a more tailored formula based on the exact pattern you need.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.