Capitalize Words in Excel: Formulas and Other Methods

Formulas & functions · Updated November 19, 2026

To capitalize the first letter of every word in Excel, use the PROPER function: if the text is in A2, enter =PROPER(A2) in another cell. For example, it changes john smith to John Smith; use UPPER for all-capital text or a different formula when you only want the first character capitalized.

Choose the kind of capitalization you need

Excel does not have a single command that means “capitalize” in every context. The right method depends on whether you want each word to begin with a capital letter, an entire entry to become uppercase, or just the beginning of a sentence to change. Excel formulas return the requested text in a new cell, so the original value remains available until you decide to replace it.

  • Title-style capitalization: PROPER changes the first letter of each word to uppercase and the other letters to lowercase.
  • All uppercase: UPPER changes every letter to uppercase.
  • All lowercase: LOWER changes every letter to lowercase.
  • Only the first character: combine text functions, taking care with spaces and punctuation.

These functions change letter case, not the underlying meaning of a word. They do not decide whether a word deserves a capital according to a writing style guide, a company’s branding rules, or a person’s preferred spelling.

Use PROPER to capitalize each word

With the source text in A2, enter this formula in B2 to capitalize each word:

=PROPER(A2)

If A2 contains MARY ANN O’NEIL, the result is Mary Ann O’Neil. If it contains green valley school with spaces at the beginning and end, the result keeps those spaces while changing the letters to Green Valley School. PROPER works with text supplied directly in a formula or returned by another cell, and it is available in Microsoft Excel for Microsoft 365 on Windows, Mac, and the web.

To use it in a worksheet, select an empty cell beside the first entry, type the formula, and press Enter. Check the result, then copy the formula down alongside the remaining records. You can drag the fill handle—the small square at the lower-right corner of the selected cell—or copy and paste the formula into the rest of the destination range. Excel adjusts A2 to A3, A4, and so on as the formula fills down.

For example, if A2 contains north coast library and A3 contains JANE DOE, the corresponding results are North Coast Library and Jane Doe. The formula does not overwrite A2 or A3; it creates a separate result in column B.

What PROPER changes—and what it does not

PROPER applies a mechanical rule: it makes the first letter of each word uppercase and converts the remaining letters in that word to lowercase. This is useful for inconsistent names, addresses, departments, and labels, but it is not a full title-case editor. Excel does not know which words a publication style guide would leave lowercase, and it cannot infer that a particular sequence of letters is an acronym.

That limitation matters for proper names and abbreviations. If A2 contains NASA RESEARCH OFFICE, PROPER returns Nasa Research Office, not NASA Research Office. If it contains iPhone SUPPORT, the result is Iphone Support. Similarly, a name such as McDONALD may become Mcdonald. Review these entries against an authoritative source or correct them manually after applying the formula.

PROPER also treats punctuation as a boundary between words in many common cases. That can produce capital letters after punctuation, as in a hyphenated term, even when your preferred spelling uses a different pattern. Apostrophes and non-English characters can also require checking, particularly when names have unusual capitalization or the workbook uses text from several languages. Treat the result as a useful first pass rather than a guarantee of editorially correct spelling.

Capitalize only the first character

If you want just the first character of an entry uppercase and the rest lowercase, and the value is in A2, use:

=UPPER(LEFT(A2,1))&LOWER(MID(A2,2,LEN(A2)))

For the input EXCEL TIPS, this returns Excel tips. LEFT takes the first character, UPPER changes it to uppercase, and MID returns the characters after it; LOWER converts those remaining characters to lowercase. The ampersand joins the two parts. This is a first-character rule, not a sentence-aware rule: it will not search past leading spaces or find the first letter after an opening quotation mark or parenthesis.

If you need to preserve the existing case after the first character, rather than forcing the rest to lowercase, use this formula with the same A2 layout:

=UPPER(LEFT(A2,1))&MID(A2,2,LEN(A2))

For example, EXcel becomes EXcel with this version, because only the first character is changed. That may be useful when the remaining capitalization has already been checked, but it will not correct a fully lowercase entry beyond its first letter. For names with leading spaces or complex punctuation, clean or handle those cases separately instead of assuming the first character is the first letter.

Apply capitalization to a full column

For a list, keep the original values in one column and put the formula in a neighboring column. If names occupy A2:A100, enter =PROPER(A2) in B2, then fill it down to B100. This layout makes it easy to compare original and converted entries, spot acronym problems, and keep a recoverable copy of the source data.

When the list is in an Excel Table, entering a formula in the adjacent table column can cause Excel to fill the calculated column for the table’s rows. Review the filled results, especially if the column contains blanks, exceptions, or manually entered values. If the data grows later, a table can make it easier to keep the formula aligned with new rows, but it does not remove the need to review special cases.

Formulas are usually preferable when the source data may change: if A2 is edited, the result in B2 updates. They are less suitable as the only copy of information you need to preserve, because deleting or changing the source can affect the output. Keep the original column until the converted data has been checked and saved as needed.

Replace the original text with the results

Once you have checked the converted entries, you can replace the original column with fixed text. First copy the formula results, then select the destination cells and use Paste Special > Values. In Excel for Microsoft 365 on Windows, the command is available from Home > Paste > Paste Values; the Paste Special dialog also offers a Values option. On Mac or Excel for the web, the formula itself works the same way, though ribbon layout and paste menus can differ slightly.

  1. Keep a copy of the original data or save a separate version of the workbook.
  2. Copy the cells containing the corrected formula results.
  3. Select the cells where the fixed text should go.
  4. Choose Paste Values so the displayed text is pasted without formulas.
  5. Check several entries, including blanks, acronyms, and names with punctuation, before removing the source column.

If you paste values over the source column, Excel replaces the original contents. Make sure the copied results are correct and that you do not need the original case before doing so. Paste Values is different from ordinary paste: ordinary paste would carry the formulas, which could then refer to the wrong cells or produce unexpected results after the source data is removed.

Use Flash Fill for a one-time cleanup

Flash Fill can recognize a pattern from examples and fill a neighboring column without leaving a formula in each result. For instance, if column A contains lowercase names, type the correctly capitalized form of the first name in B2. Type a second example in B3 if needed so Excel has a clearer pattern, then choose Data > Flash Fill. Review the generated entries before relying on them; pattern recognition can misread exceptions, abbreviations, and names that do not follow the examples.

Flash Fill is handy when you want a one-time set of text results and do not need them to update when the source changes. A formula is more transparent and repeatable for a standard rule, particularly across a long list. You can also use both: generate a draft with Flash Fill, inspect it, and make any corrections manually.

Common problems and how to fix them

  • The formula appears as text: Check that the cell is not formatted as Text, and confirm the entry begins with an equals sign. Change the cell format to General, then re-enter the formula if necessary.
  • The formula shows an error or does not calculate: Check that the source reference points to the intended cell and that the formula’s parentheses are complete. Excel’s calculation mode can also be set to manual; if values are not updating, check Formulas > Calculation Options.
  • Acronyms or brand names look wrong: This is expected with PROPER because it lowercases the remaining letters. Correct those results manually or use a tailored process for the exceptions.
  • Extra spaces remain: Case functions do not remove leading, trailing, or repeated spaces. Clean the text separately if spacing is a problem, and inspect the result before replacing source data.
  • Only some rows change: Confirm the formula was filled through the entire intended range and that no existing values or merged cells interrupted the destination column.

In Microsoft 365, the formulas use commas between arguments as shown here in a standard English-language setup. Excel’s list separator can depend on regional settings, so some installations may display or expect a different separator. If Excel rejects a correctly structured formula, check the separator settings used by that installation rather than changing the function name at random.

Which method should you use?

For a repeatable conversion of every word in a column, use PROPER in a separate column and review its output. Use UPPER or LOWER when the requirement is consistently all capitals or all lowercase. Use a first-character formula only when that specific rule fits the data. Choose Flash Fill for a quick, one-time transformation when a few examples describe the desired result clearly.

The amount of review needed depends on the material. A list of ordinary street names may need only a spot check, while employee names, legal names, product brands, acronyms, and multilingual text deserve closer attention. Excel can apply a consistent letter-case rule quickly, but it cannot know the correct spelling of every special case. For important records, keep the source data and validate the converted values before using them elsewhere.

Frequently Asked Questions

Does Excel have a Capitalize button?
Excel for Microsoft 365 does not provide a general worksheet button that applies sentence or title capitalization to selected cells. Use PROPER, UPPER, LOWER, a first-character formula, or Flash Fill depending on the result you want.

How do I capitalize the first letter of each word in Excel?
If the text is in A2, enter =PROPER(A2) in another cell. PROPER capitalizes each word mechanically, so check the output for acronyms and names with special spellings.

How do I make all text uppercase in Excel?
With the original text in A2, enter =UPPER(A2) in a neighboring cell. It converts every letter to uppercase; it does not alter numbers or punctuation.

Can I change the capitalization without a formula?
For a one-time conversion, try Data > Flash Fill after entering one or more examples in a neighboring column. Check the results because Flash Fill may not identify exceptions correctly.

Will the capitalization formula update when I change the original?
Yes. A formula such as =PROPER(A2) recalculates when A2 changes. If you need a permanent text result instead, copy the results and paste them as values after checking them.

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.