Capitalize Each Word in Excel with the PROPER Formula

To capitalize the first letter of each word in Excel, enter =PROPER(A2) in an empty column beside the text in A2, then fill the formula down. Excel’s PROPER function makes the first letter of each word uppercase and the other letters lowercase, so it is useful for standardizing names, labels, and lists. Keep the original column until you have checked the results.

What You’ll Need

A workbook in Microsoft Excel for Microsoft 365 on Windows. PROPER is also available in Excel for Mac and Excel for the web, although ribbon layouts can differ slightly.
A column of text to change and an empty column for the results. For example, the source text can be in A2:A20, with the formula results going in B2:B20.
Permission to edit the workbook. If the source data is important, save a copy before replacing anything.

Step-by-Step

Check the source data. Find the column containing the words you want to capitalize. Look for a header row, blank rows, and any cells that should stay unchanged, such as product codes or acronyms. Using an empty neighboring column for the results lets you compare the new text with the original before committing to the change.
Choose the first result cell. If the source text starts in A2 and row 1 contains a header, select B2. If your data begins on a different row or in a different column, choose an empty cell on the same row as the first source entry. Do not enter the formula over the source text, because that can replace data you may need.
Enter the PROPER formula. With the source value in A2 and the result cell in B2, enter =PROPER(A2) in B2 and press Enter. For example, if A2 contains mARIA lopez, the result is Maria Lopez. The formula refers to the source cell, so changing A2 later will update the result in B2.
Check how the formula treats your text. PROPER changes case; it does not decide which words should be capitalized according to a particular style guide. It generally capitalizes a letter after a space or punctuation mark and lowercases the remaining letters in each word. For instance, text such as NORTH-WEST becomes North-West, while O’NEILL becomes O’Neill. Check unusual names and codes against the original.
Fill the formula down the column. Select B2 and point to the small square at the lower-right corner of the cell, called the fill handle. Drag it down to the last row of source data. You can also double-click the fill handle when the adjacent source column has a continuous set of entries; Excel will usually fill down to match that data. Check the last row to make sure the formula reached it.
Review the results before using them. Compare the new column with the original, looking especially at initials, acronyms, hyphenated terms, apostrophes, and cells that contain numbers or punctuation. If a result is not appropriate, edit that value manually in the results column, or keep the original wording and use a different method for that entry.
Keep formulas or replace them with fixed text. Leave the formulas in place if you want the results to update when the source changes. If you need the capitalized text to stand on its own, select the completed result range, copy it, then use Home > Paste > Values to paste the displayed text over the formulas. Verify the pasted values before deleting the source column. In Excel for Mac, use the same Paste Values command if it appears in the Home tab; on the web, the wording or location may vary slightly.
Update the header and finish the sheet. Give the results column a clear heading, such as Proper Case, so it is not confused with the untouched source. If you have converted the results to values and confirmed them, you can remove the old column if your workflow requires it. Save the workbook when you are satisfied.

For a single cell, the same method works without filling down: enter the formula in a separate cell and use the result wherever needed. In a formatted Excel table, entering the formula in the first cell of a new table column may automatically fill the formula through that column. Check the remaining rows, especially if the table contains blank entries or special-case values.

Common Mistakes

Typing over the source column. A formula that refers to its own cell can create a circular reference, and overwriting the source can make it difficult to recover the original. Put results in a separate column first.
Expecting title-style exceptions. PROPER capitalizes each word without understanding grammar or editorial conventions. It may capitalize short words such as and or of, even when a style guide would leave them lowercase in a title.
Assuming acronyms stay uppercase. PROPER changes the rest of each word to lowercase, so an acronym such as NASA may become Nasa. Review abbreviations, initials, and brand names individually.
Thinking the result is a formatting change. PROPER returns changed text; it does not apply a visual font effect or preserve the original capitalization. If you need both versions, keep the source column.
Filling too far or not far enough. Dragging the fill handle beyond the data can create extra results, while stopping early leaves some rows unchanged. Check the first and last result cells against the source range.
Removing the original too soon. Formula results depend on the cells they reference. Deleting the source before converting formulas to values can cause errors or remove the information needed to correct an unexpected result.

Tips

Use a working copy for critical data. Keeping an unchanged source column makes it easy to compare values, restore a name, or apply a different capitalization rule later.
Filter or sort carefully. If you are working with a filtered list, check which rows are visible and whether the fill operation covered the intended records. For a table, confirm the result column aligns with the correct records after sorting.
Check for extra spaces. PROPER does not remove spaces at the beginning or end of a cell. If spacing is also a problem, clean it separately and check the result; Excel’s TRIM function removes many ordinary extra spaces, but not every kind of whitespace.
Use Find to review known exceptions. Search for common acronyms, company names, or codes after filling the formula, then correct only the results that need special treatment.
Remember the shortcut difference. On Windows, Ctrl+C copies a selected range. On Mac, use Command+C. Pasting values through the ribbon avoids relying on a keyboard sequence that may differ by Excel version or keyboard layout.
Use Flash Fill only when appropriate. Flash Fill can infer a text pattern from examples, but it may not apply a consistent rule to every row. PROPER is usually the more predictable choice when the desired transformation is simply capitalization of each word.

Troubleshooting

The formula appears as text instead of a result: Check that the cell does not have the Text number format. Change it to General from Home > Number Format, then select the cell, press F2, and press Enter to re-enter the formula. Also check that there is no apostrophe before the equals sign.

The result shows #NAME? or another error: Confirm that the function is spelled PROPER and that the cell reference exists. In Excel, this function is written with the English name shown here; if the workbook is opened in a localized version, function names or separators may be displayed differently. Make sure the source cell is not itself an error value.

Only the first row changed: The formula may not have been filled down. Select the cell with the working formula and drag its fill handle through the remaining data rows, or copy the cell and paste it into the intended range. Check that each result row refers to the source cell on the same row.

Some rows are blank or show unexpected text: Inspect the corresponding source cells. A blank source produces a blank-looking result, and PROPER does not repair misspellings, remove unwanted characters, or infer missing words. Check for nonprinting characters or unusual spaces if text appears separated in an unexpected way.

Acronyms or names look wrong: This is usually a limitation of the capitalization rule rather than a formula error. Correct those entries manually in the results, or retain the original spelling for the exceptional values. If the list is large, make a small exception list and review it before replacing formulas with values.

Paste Values is unavailable or pastes formulas: Re-select and copy the result cells, then open the Paste menu on the Home tab and choose Values or the values-only clipboard option. In Excel for the web, check the available paste options in the ribbon or context menu. Confirm that the formula bar shows plain text rather than a formula after pasting.

Frequently Asked Questions

What Excel function capitalizes the first letter of each word?
Use PROPER. It capitalizes the first letter in each word and lowercases the other letters. Enter it in a separate cell that refers to the source text, then fill it down if needed.

Can I capitalize each word in place without a helper column?
PROPER is a worksheet function, so it needs a cell in which to return its result. Use a temporary helper column, review the output, and then copy it and choose Home > Paste > Values if you want the text in the original location. Keep a backup if you may need the original case.

Does PROPER preserve acronyms and brand names?
No. It applies a general capitalization pattern and may change acronyms, product names, or stylized spellings. Review those values and correct exceptions after applying the function.

Will PROPER capitalize every word after a hyphen or apostrophe?
It commonly treats punctuation as a boundary, so a letter after a hyphen or apostrophe may be capitalized. That behavior can suit some names but not all naming conventions. Check the actual results rather than assuming every punctuation case will match your preference.

Does the formula work in Excel for Mac and Excel for the web?
Yes. PROPER is available in both, and the formula works the same way. Ribbon placement and paste options can vary, so look for the Paste Values command in the Home tab or the paste menu.

Can PROPER capitalize only the first word of a sentence?
No. PROPER capitalizes the first letter of every word, so it is not a sentence-case tool. It also cannot determine sentence boundaries or preserve special capitalization rules automatically.

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.