Capitalize the Whole Word in Excel: Formulas and Tips

Formulas & functions · Updated November 20, 2026

To capitalize every letter in a word or cell in Excel, use the UPPER function: if the original text is in A2, enter =UPPER(A2) in another cell. If you mean capitalize only the first letter of each word, use =PROPER(A2) instead.

What “capitalize the whole word” means in Excel

People use “capitalize” to describe two different changes. One is making every letter uppercase, as in excel tips becoming EXCEL TIPS. The other is title-style capitalization, where the first letter of each word is uppercase and the rest are lowercase, as in Excel Tips. Excel has a function for each: UPPER and PROPER.

Excel does not have a general Change Case button on the Home ribbon like some word-processing programs do. The usual solution is to create the changed text with a formula in a spare column, then, if needed, replace the original values with the results. This approach is useful for one cell or thousands of rows and leaves the source text intact until you decide to replace it.

Make every letter uppercase with UPPER

With the text in A2, select an empty cell such as B2, type the formula below, and press Enter. Replace A2 with the address of the cell containing your text.

With the original text in A2, this formula returns an uppercase version in B2: =UPPER(A2). For example, if A2 contains monthly sales report, the result is MONTHLY SALES REPORT.

UPPER changes lowercase letters to uppercase throughout the text. It preserves spaces, punctuation, and digits: Room 4, west wing becomes ROOM 4, WEST WING. It works on a phrase in one cell as well as a single word. It does not change the text stored in A2; it displays a transformed result in the formula cell.

To apply it to a list, put the formula beside the first entry and fill it down:

  1. Enter the formula in B2, assuming the first source value is in A2.
  2. Select B2 and point to the small square at its lower-right corner, called the fill handle.
  3. Drag the fill handle down the rows, or double-click it to fill alongside a contiguous list in column A.
  4. Check a few results, especially at the bottom of the list, before using them to replace anything.

Excel adjusts the relative reference as it fills: the next row uses A3, then A4, and so on. In Microsoft 365 for Windows, you can also copy B2, select the destination range, and paste to fill the formula down.

Capitalize the first letter of each word with PROPER

If the intended result is Monthly Sales Report, rather than MONTHLY SALES REPORT, use PROPER. With the original phrase in A2, enter =PROPER(A2) in B2. The result for monthly sales report is Monthly Sales Report.

PROPER changes the first letter of each word to uppercase and changes the other letters in those words to lowercase. This is convenient for consistently formatted labels, but it is not a grammar-aware title-case tool. It may change acronyms and brand styling: NASA launch plan becomes Nasa Launch Plan, for example. Review the output when names, abbreviations, or special capitalization matter.

PROPER also treats punctuation and spaces as word boundaries in ways that can produce results you may not expect. A name such as o’connor may become O’Connor, which is often suitable, but capitalization conventions vary. Check people’s names and official organization names against a reliable source rather than assuming a formula knows the preferred spelling.

Choose the right function for the result

Use the function that matches the desired appearance, not simply the one that sounds closest to “capitalize.” A quick comparison makes the distinction clear. With jordan lee in A2:

  • =UPPER(A2) returns JORDAN LEE.
  • =PROPER(A2) returns Jordan Lee.
  • =LOWER(A2) returns jordan lee.

Each example assumes the source text is in A2 and the formula is entered in another cell. LOWER is useful when you need all letters lowercase, such as standardizing text before a comparison. These functions affect letter case; they do not correct spelling, remove unwanted spaces, or determine whether a phrase follows a style guide.

For an all-caps product code, UPPER may be appropriate. For a sentence, making every word uppercase is usually a formatting choice rather than normal sentence capitalization. For names or headings, PROPER can be a starting point, but manual review is important because it may lowercase letters that must remain uppercase.

Apply the results to a full column

For a larger list, keep the source column and output column separate while checking the results. For example, if names occupy A2:A100, enter the UPPER formula in B2 and fill it through B100. The original entries remain available in column A, so you can compare records or correct an exception before committing the change.

When the results are correct and you want them to replace the original text, copy the output cells. Select the first original cell, then use Home > Paste > Paste Values. This pastes the displayed text rather than formulas that refer back to the output column. In Excel for Mac, the Paste Values option is also available from the Home tab’s Paste menu; the exact menu presentation can vary by release. You can also right-click the destination and choose the values-only paste option if it appears.

After pasting values, check a few cells and save the workbook. If the data is important, keep a backup or retain the original column until you are certain the replacement is correct. Copying and pasting values is a one-way change to those cells unless you undo it promptly or restore the original data.

Use Flash Fill for a one-time pattern

Flash Fill can infer a text pattern from examples, which may help when you want a one-time result rather than formulas. For example, enter an uppercase version of the first source entry in the adjacent column, then begin the next example. If Excel recognizes the pattern, it may preview the remaining results. Choose the preview or use Data > Flash Fill. In Excel for Windows, Ctrl+E is the Flash Fill shortcut.

Flash Fill is pattern-based rather than a live formula: if the source entries change later, the filled results do not automatically recalculate. It can also infer an unintended pattern, so inspect the whole output before relying on it. If Excel does not show a preview, use UPPER or PROPER, which state the transformation directly. Flash Fill availability and controls can differ by Excel version and platform.

Common problems and how to fix them

  • The original cell did not change. That is expected: UPPER and PROPER return a result in the formula cell. Copy that result and paste values over the original only when you are ready.
  • The formula appears as text. Check whether the cell is formatted as Text or whether there is an apostrophe before the equals sign. Change the cell format to General, then re-enter the formula.
  • The formula is visible instead of its result. The cell may be in Show Formulas mode. Press Ctrl+` on Windows to toggle it, or check Formulas > Show Formulas. On Mac, the keyboard shortcut differs by keyboard and Excel release; the ribbon command is a reliable way to check.
  • Only the first row changed. Fill the formula down the rest of the rows. Make sure each row points to its own source cell rather than repeating a fixed reference by mistake.
  • Acronyms or names look wrong. PROPER lowercases letters after the initial of each word, which can alter names, abbreviations, and brands. Correct those exceptions manually after reviewing the output.
  • There are unexpected spaces. UPPER and PROPER do not clean leading, trailing, or repeated spaces. If spacing is the problem, address it separately rather than expecting a case function to fix it.

Excel for the web and Mac considerations

UPPER, PROPER, and LOWER are standard Excel worksheet functions and work in Microsoft 365 on Windows, Excel for Mac, and Excel for the web. Enter the formula in a cell and fill or copy it down as you would in the desktop app. The core formula does not change across these versions.

Some keyboard shortcuts and ribbon layouts do differ. The Windows shortcut Ctrl+E invokes Flash Fill in supported desktop versions; on a Mac, use the Data tab’s Flash Fill command if it is available rather than assuming the same key combination. Excel for the web may have a more limited or changing set of desktop features, but the case-conversion formulas remain a dependable option. If you cannot find a command, use the formula method instead.

Frequently Asked Questions

How do I make all text uppercase in Excel?
With the text in A2, enter =UPPER(A2) in another cell. Fill the formula down for more rows. The result is uppercase text, while the source remains unchanged until you replace it.

How do I capitalize only the first letter of each word?
Use PROPER. If the source is in A2, enter =PROPER(A2). It capitalizes the first letter of each word and lowercases the remaining letters, so check acronyms and names before using the results.

Can I change the text in place without a formula?
Excel does not provide a standard Change Case command on the Home ribbon. Create the transformed text with UPPER or PROPER, copy the results, and use Paste Values over the original cells if you want a permanent replacement.

How do I capitalize an entire column?
Put a case formula beside the first entry, then fill it down the column. Review the output and, if it is correct, copy it and paste values into the original column or keep the transformed results in a separate column.

Why did PROPER change my acronym?
PROPER applies a consistent word pattern; it does not recognize acronyms or brand-specific capitalization. It may turn an all-caps abbreviation into a capitalized word. Correct those cases manually or retain the original spelling where exact capitalization matters.

Which method should you use?

For a repeatable conversion that updates when source text changes, use UPPER for all-uppercase text or PROPER for first-letter capitalization. Use Flash Fill for a small, one-time transformation when Excel correctly recognizes the example pattern. If you need to permanently replace the source values, paste the reviewed results as values. Keeping those distinctions in mind prevents the most common mistake: expecting a formula to edit the original cell automatically.

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.