How to Capitalize Each Word in Excel

To capitalize each word in Excel, type =PROPER(A2) in an empty column next to your text, fill it down, then copy the results and paste them back over the original as Values. PROPER turns “jANE o’neil” into “Jane O’Neil” and works in Excel for Microsoft 365, 2016 through 2024, and Excel for Mac.

You pasted a column of names or titles into Excel and they are all lowercase or all caps. Excel has no Change Case button like Word does, so you use a formula, Flash Fill or Power Query.

Which Method Fits Your Data?

MethodBest forTrade-off
PROPER formulaMost lists, any sizeNeeds a helper column and a paste-values step
Flash Fill (Ctrl+E)Short, consistent lists when you don’t want a formulaGuesses from a pattern, so check every row
Power QueryExports you clean again every week or monthMore setup, but a refresh repeats the cleanup

Capitalize Each Word With the PROPER Function

Microsoft’s PROPER function reference says it capitalizes the first letter in a text string and any other letter that follows a character other than a letter, and it converts all other letters to lowercase. A helper column is a temporary column you add just to hold the formula results.

In this example, column A of a fictional mailing list for Larkspur Bakery holds customer names starting in A2, with a header in A1.

  1. Right-click the column B header and choose Insert to add an empty helper column (skip this if column B is already empty).
  2. Click B2 and type =PROPER(A2), then press Enter. If A2 says “MARGARET HOLLOWAY”, B2 now shows “Margaret Holloway”.
  3. Click B2 again and double-click the fill handle, the small square at the bottom-right corner of the cell. Excel copies the formula down to the last row of data in column A.
Excel names capitalized in column B with the PROPER formula in the formula bar
Illustration: Double-clicking the fill handle copies the formula down.
  1. Scroll through column B and compare it with column A before you go further.

If your data is formatted as an Excel table, you don’t need to fill down: Microsoft notes that a formula entered in a table column fills the rest of the column automatically.

Imported text often has stray spaces too. Use =PROPER(TRIM(A2)) to remove extra spaces at the start and end and between words while you fix the case.

Replace the Original Text With the Results

Column B still holds formulas that depend on column A. If you delete column A now, column B turns into #REF! errors. Converting the results to plain values first avoids that. Before you start, save a copy of the workbook or keep the original column until you’ve checked the results.

  1. Select the results in column B (B2 down to the last row) and press Ctrl+C.
  2. Right-click A2, the first cell of the original text.
  3. Under Paste Options, choose Values. Column A now holds the capitalized text with no formulas.
Excel right-click Paste Options with Values highlighted
Illustration: Values keeps the text and drops the formula.
  1. Right-click the column B header and choose Delete to remove the helper column.

These are the same steps in Microsoft’s article on how to change the case of text in Excel. If you pasted the wrong range, press Ctrl+Z right away to undo.

Capitalize Each Word With Flash Fill

Flash Fill watches what you type in a column next to your data and fills in the rest following the same pattern. Microsoft’s Flash Fill help shows names being combined rather than case changes, so treat it as a pattern match that often works, not a guaranteed result.

  1. In B2, type the first name exactly as you want it, such as “Margaret Holloway”, and press Enter.
  2. Start typing the second entry in B3. If Excel shows a grey preview for the rest of the column, press Enter to accept it.
Excel Flash Fill showing a gray preview of capitalized names
Illustration: Press Enter to accept the preview.
  1. If no preview appears, click B3 and press Ctrl+E, or go to Data > Flash Fill.
  2. Check every row. Flash Fill can misread names with prefixes, initials or extra words.

If Flash Fill never suggests anything, it may be turned off. On Windows, Microsoft’s steps to enable Flash Fill in Excel are File > Options > Advanced, check Automatically Flash Fill, click OK and restart Excel. The live post on using Flash Fill in Excel covers more patterns and fixes.

Capitalize Each Word With Power Query

Power Query is Excel’s built-in tool for importing and cleaning data (Data tab, Get & Transform Data group). It’s worth the setup when you receive the same export over and over, because the cleanup is saved as a step. The command behind it is the M function Text.Proper, which Microsoft describes as capitalizing the first letter of each word and returning all other letters in lowercase.

Microsoft documents the function but not the exact menu labels for this task, so the names below may differ slightly in your version:

  1. Click any cell in your data and choose Data > From Table/Range. If the data isn’t a table yet, Excel asks you to confirm the range and whether it has headers.
  2. In the Power Query Editor, click the header of the column to fix.
  3. On the Transform tab, open Format and choose Capitalize Each Word. You can also right-click the column header and look under Transform.
Power Query Editor Format menu with Capitalize Each Word highlighted
Illustration: Power Query can repeat this on new data.
  1. Click Home > Close & Load. Excel loads the cleaned data to a new worksheet as a table.

When new rows are added to the source table, right-click the loaded table and choose Refresh (or use Data > Refresh All) to run the cleanup again. Your original data stays untouched, which makes this the safest method for shared files.

Use UPPER or LOWER for All Caps or All Lowercase

The same helper column steps work with two other functions. =UPPER(A2) converts every letter to uppercase, so “total” becomes “TOTAL”, according to Microsoft’s UPPER function page. =LOWER(A2) converts uppercase letters to lowercase and leaves characters that aren’t letters unchanged. UPPER doesn’t capitalize each word; it capitalizes every letter, which suits product codes or state abbreviations rather than names.

For sentence case, where only the first letter of the cell is capitalized, combine them: =UPPER(LEFT(A2,1))&LOWER(MID(A2,2,LEN(A2))). That gives “Fresh rye loaf” from “FRESH RYE LOAF”.

What PROPER Gets Wrong and How to Fix It

Because PROPER capitalizes any letter that follows a non-letter and lowercases everything else, some text comes out wrong. Microsoft’s own examples show “2-way street” becoming “2-Way Street” and “76BudGet” becoming “76Budget”. Applying the same rule to common data gives:

OriginalPROPER resultProblem
o’neilO’NeilCorrect for this name
don’t stopDon’T StopLetter after the apostrophe is capitalized
3rd avenue3Rd AvenueLetter after a digit is capitalized
NASA grantNasa GrantAcronyms lose their capitals
McDonaldMcdonaldInner capitals are lowercased
state-of-the-artState-Of-The-ArtEvery word after a hyphen is capitalized

Fix these after you’ve pasted the results as values. Press Ctrl+H to open Find and Replace, type the wrong form (for example ‘T) in Find what and the right form (‘t) in Replace with, then click Options and check Match case so other text isn’t changed. Click Find All first to see which cells will change (that example would also turn O’Toole into O’toole), then Replace All or replace cells one at a time. For a short list, editing the few odd cells by hand is quicker.

Watch for names that were split or joined from other columns. If you’re building full names, combining first and last names in one cell before running PROPER means you fix the case only once. Google Sheets has a PROPER function too, with the same syntax.

Questions About PROPER and Capitalization

Can I Capitalize Each Word Without a Second Column?

Not with a formula. A formula can’t change the cell it refers to, which is why Microsoft’s method uses a temporary column that you paste back as values. Power Query also writes its result to a separate table. If you want the final sheet to have one column, use the paste-values step and delete the helper.

Will Flash Fill Update if I Change the Original Cells?

Microsoft doesn’t say, but Flash Fill enters plain text rather than formulas: click a filled cell and the formula bar shows text, not a formula. If you edit the source names later, run Flash Fill again or use PROPER, which recalculates on its own.

Why Does My PROPER Formula Show as Text Instead of a Result?

The helper cell is probably formatted as Text, or the formula starts with an apostrophe. Change the cell format to General on the Home tab, remove any leading apostrophe, then click in the cell, press F2 and press Enter. If every formula on the sheet shows as text, Show Formulas is on: turn it off on the Formulas tab.

Does This Work in Excel for the Web and on a Mac?

Microsoft’s PROPER page lists Excel for Microsoft 365 for Mac and Excel 2024, 2021 for Mac, and Flash Fill is documented for Excel for the web as well as Mac. PROPER is a standard worksheet function, so the formula steps should work in Excel for the web too.

Next step: try =PROPER(TRIM(A2)) on a copy of your list, scan the results for the problem patterns above, and paste the values back once they look right.