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?
| Method | Best for | Trade-off |
|---|---|---|
| PROPER formula | Most lists, any size | Needs a helper column and a paste-values step |
| Flash Fill (Ctrl+E) | Short, consistent lists when you don’t want a formula | Guesses from a pattern, so check every row |
| Power Query | Exports you clean again every week or month | More 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.
- Right-click the column B header and choose Insert to add an empty helper column (skip this if column B is already empty).
- Click B2 and type
=PROPER(A2), then press Enter. If A2 says “MARGARET HOLLOWAY”, B2 now shows “Margaret Holloway”. - 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.

- 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.
- Select the results in column B (B2 down to the last row) and press Ctrl+C.
- Right-click A2, the first cell of the original text.
- Under Paste Options, choose Values. Column A now holds the capitalized text with no formulas.

- 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.
- In B2, type the first name exactly as you want it, such as “Margaret Holloway”, and press Enter.
- Start typing the second entry in B3. If Excel shows a grey preview for the rest of the column, press Enter to accept it.

- If no preview appears, click B3 and press Ctrl+E, or go to Data > Flash Fill.
- 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:
- 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.
- In the Power Query Editor, click the header of the column to fix.
- On the Transform tab, open Format and choose Capitalize Each Word. You can also right-click the column header and look under Transform.

- 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:
| Original | PROPER result | Problem |
|---|---|---|
| o’neil | O’Neil | Correct for this name |
| don’t stop | Don’T Stop | Letter after the apostrophe is capitalized |
| 3rd avenue | 3Rd Avenue | Letter after a digit is capitalized |
| NASA grant | Nasa Grant | Acronyms lose their capitals |
| McDonald | Mcdonald | Inner capitals are lowercased |
| state-of-the-art | State-Of-The-Art | Every 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.

Matthew Burleigh is the founder, head writer, and editor of Solve Your Tech, which he launched in 2012. He has written technology tutorials since 2008 and worked in IT since 2003, including small-business support, IT management, and consulting. He holds Bachelor’s and Master’s degrees in Computer Science from Arizona State University.
Matthew writes practical guides for Windows, iPhone and iPad, Microsoft Office, Outlook, Google apps, and Android. Solve Your Tech’s guides are checked step by step against the device or app maker’s own documentation and tested on his own devices whenever he has the hardware or software, with clear steps, sources, and update dates.
Read more about Matthew and how Solve Your Tech writes and updates its guides, or report a correction.