Formula to Capitalize Each Word in Excel

Formulas & functions · Updated November 20, 2026

In Excel, use the PROPER function to capitalize the first letter of each word: with the text to change in A2, enter =PROPER(A2) in another cell. For example, it changes mARY ann jONES to Mary Ann Jones; the original cell stays unchanged until you replace it or copy the result over it.

The Excel formula and what it returns

PROPER is Excel’s built-in function for changing text to “proper case,” often called title case or initial capitals in everyday use. Its syntax is simple: provide the text, or a cell reference containing text, inside the parentheses. The function returns a revised text value; it does not change the formatting or contents of the source cell.

With a name in A2, enter =PROPER(A2) in B2. If A2 contains mARY ann jONES, B2 displays Mary Ann Jones. The same formula works for a phrase such as MONTHLY SALES REPORT, returning Monthly Sales Report. You can also type text directly into the function, but a cell reference is usually easier to reuse and maintain.

PROPER is available in Microsoft Excel for Microsoft 365 on Windows, as well as Excel for Mac and Excel for the web. The function name and basic formula are the same in those versions. It is not a feature limited to a new Microsoft 365 release.

Apply the formula to a list

For a column of names or labels, enter the formula beside the first item, then fill it down. For example, if the original entries are in A2:A100, use this sequence:

  1. Click B2, next to the first source entry.
  2. Type =PROPER(A2) and press Enter. Check that the returned capitalization is suitable.
  3. Select B2 again, then drag the small fill handle at the lower-right corner of the cell down to the last row. You can also select the destination range and choose Home > Fill > Down.
  4. Review the results, especially entries with initials, apostrophes, hyphens, or abbreviations.

Excel adjusts the relative reference as the formula is filled: in B3 it refers to A3, in B4 to A4, and so on. Keep the source and result columns separate while checking the output. If the range is an Excel table, entering a formula in the adjacent table column may fill the formula down that column automatically.

For a one-off conversion, you do not need to create a complicated formula or use a macro. A second column gives you a chance to compare the original with the transformed text before deciding whether to keep the change.

How PROPER decides where words begin

PROPER capitalizes the first letter in the text and letters that follow a character that is not a letter; it changes the other letters to lowercase. Spaces are the usual word separators, but punctuation can affect the result too. For instance, it will generally turn anne-marie into Anne-Marie and o’neill into O’Neill, because a hyphen or apostrophe separates letters for this rule.

This is a mechanical text rule, not a language-aware editor. It does not know whether a word is a person’s preferred spelling, a brand, an acronym, or a grammatical exception. If the cell contains NASA, the result is Nasa; if it contains iPhone, it becomes Iphone. Names such as McDONALD may become Mcdonald. These outputs can be technically consistent with PROPER while still being wrong for the person or organization.

Capitalization conventions also vary. Some style guides lowercase short connecting words in titles, while others capitalize them; PROPER capitalizes every word-like part without applying a style guide. A name such as “van der Waals” may be changed to “Van Der Waals,” even if the original capitalization was intentional. Treat the result as a useful first pass, not an authoritative correction.

Clean extra spaces before changing case

Imported data can contain leading spaces, trailing spaces, or multiple spaces between words. PROPER changes letter case but does not remove those extra spaces. If A2 contains two leading spaces, three spaces between words, and trailing spaces, use TRIM around the reference to clean ordinary extra spaces at the same time.

With the source text in A2, enter =PROPER(TRIM(A2)). If A2 contains the text with extra spaces around mARY and between ann and jONES, the result is Mary Ann Jones with single spaces between words and no leading or trailing spaces. TRIM does not remove every kind of invisible character, however, so a result may still look oddly spaced if the data came from a website or another system.

A frequent culprit is a nonbreaking space, which looks like an ordinary space but is a different character. For a cell A2 that contains nonbreaking spaces, replace those characters with regular spaces before applying PROPER. This formula assumes the text to clean is in A2:

=PROPER(SUBSTITUTE(A2,CHAR(160),CHAR(32)))

SUBSTITUTE changes character 160, commonly used for a nonbreaking space, to character 32, an ordinary space; PROPER then changes the case. This is useful when copied web text appears to have spaces but TRIM does not behave as expected. It is not a universal data-cleaning solution: imported text can contain other invisible characters that need separate diagnosis.

Keep the result or replace the original

A formula result depends on its source. If you edit A2 later, B2 recalculates, which is helpful when the source list is still being maintained. If you need a fixed list, copy the result cells and paste their values over the same cells or into a different destination. In Excel for Microsoft 365 on Windows, use Home > Paste > Values after copying; Excel for Mac and the web also offer a Paste Values option, though the surrounding ribbon layout can differ slightly.

Before replacing the source column, keep a backup or confirm that the converted values are correct. If you paste values over the source cells, the formulas are removed and the displayed text becomes fixed. If you paste values into a new column instead, the original remains available for reference.

Be careful about sorting or deleting rows while formulas refer to a separate source range. Excel usually adjusts cell references as rows move or are removed, but a clear source-and-result layout reduces the chance of confusing a formula with a final value. For repeatable work, label the columns—for example, Original Name and Standardized Name—until review is complete.

When another approach is better

PROPER is convenient when the goal is consistent capitalization, but it is not always the right tool. Choose an alternative based on whether you want a quick pattern, a carefully curated result, or an automated repeatable process.

  • Flash Fill: Type the desired version beside one or two examples, then choose Data > Flash Fill. Excel attempts to infer the pattern and fill the remaining rows. It can preserve custom capitalization such as acronyms if the examples make the pattern clear, but review the output because pattern inference can be inconsistent.
  • Manual correction: For a short list, directly edit exceptions such as company names, initials, or culturally specific name forms. This is often safer than trying to make a single formula recognize every naming convention.
  • Power Query: For a recurring import, Power Query offers text transformations that can be applied again when refreshing data. Its capitalization choices still follow rules rather than personal knowledge, so exceptional names may need an additional correction step.
  • Leave the source as entered: If capitalization is legally, culturally, or brand-significant, do not automatically standardize it without a reliable reference. A consistent-looking result is not necessarily a correct one.

Flash Fill creates filled values rather than a formula that continuously responds to changes in the source. PROPER, by contrast, recalculates from its referenced cell. That distinction matters when source data changes regularly: use formulas for live transformation, or a repeatable query process for recurring imports, and check exceptions either way.

Common mistakes and troubleshooting

If Excel displays the formula instead of a result, check that the cell is not formatted as Text. Change its number format to General, then re-enter the formula. Also check whether Show Formulas is turned on; pressing Ctrl+` on Windows toggles that view, and the equivalent key combination can vary with Mac keyboard layout. A formula entered without the initial equals sign is treated as ordinary text.

If the formula returns an unexpected result, confirm that the reference points to the intended source cell and inspect the original data for punctuation or hidden spaces. A formula in B2 that refers to A2 will not transform a value typed into another column. If the result is correct but the source appears unchanged, that is expected: the formula creates a result in its own cell.

Another common misconception is that “capitalize each word” means producing professionally styled headings. PROPER does not decide which words should remain lowercase in a title, preserve acronyms, or validate spelling. It only applies a predictable capitalization rule. For publication-ready titles or names, review the output against the relevant style guide or an authoritative source.

Frequently Asked Questions

What is the Excel formula to capitalize each word?
Use =PROPER(A2) when the text is in A2. It returns text with the first letter of each word-like segment capitalized and the other letters changed to lowercase.

How do I capitalize a whole column in Excel?
Put the PROPER formula beside the first entry, then fill it down to the remaining rows. Review the results, and paste values if you want fixed text rather than formulas.

Does PROPER preserve acronyms such as NASA?
No. It generally converts NASA to Nasa because it lowercases letters after the first letter in a word. Correct acronyms or brand names manually, or use an approach with explicit examples and review.

Can Excel capitalize each word without a formula?
Yes. Flash Fill may infer the desired capitalization from examples: type the corrected text in an adjacent column and choose Data > Flash Fill. Check the output carefully, since it does not create a live formula.

How do I remove extra spaces while capitalizing?
With the source text in A2, use =PROPER(TRIM(A2)) to remove ordinary leading and trailing spaces and reduce repeated ordinary spaces between words. Nonbreaking spaces may require a separate replacement step.

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.