Capitalize All Names in Excel with PROPER and Fill Down

How-to basics · Updated November 20, 2026

To capitalize names in Excel, enter =PROPER(A2) in a blank column beside the first name, then fill the formula down the list. PROPER changes text to title case, so each word starts with a capital letter and its other letters become lowercase. Keep the original column until you have checked the results; names with unusual spelling may need manual correction.

What You’ll Need

  • An Excel workbook containing the names you want to format. These instructions are for Microsoft Excel for Microsoft 365 on Windows; the same formula works in current Excel for Mac and Excel for the web.
  • A blank column for the converted names, unless you have a safe way to preserve a copy of the original data. Do not overwrite your only copy before checking the output.
  • A quick understanding of the result you want. PROPER creates capitalization such as Jane Smith. If you mean every letter uppercase, use the alternative described below instead.

Step-by-Step

  1. Check the source list. Find the column containing names and note its first and last populated rows. For example, if the header is in A1 and the first name is in A2, leave the header in place and work with the rows below it. Look for blank rows, extra spaces, titles, or other text that is mixed into the list. Those details affect how you fill and review the results.
  2. Add a results column. Insert or choose an empty column beside the names. If the originals are in column A, use column B. Give the new column a clear heading such as Formatted Name in B1. Keeping the converted names separate lets you compare them with the source and makes it easy to undo the process without restoring a backup.
  3. Enter PROPER in the first data row. With names in A2:A20 and the output beginning in B2, enter =PROPER(A2) in B2 and press Enter. The reference A2 tells Excel to format the name on that same row. For instance, if A2 contains jAmES brown, the result in B2 is James Brown. If your data starts on a different row or is in a different column, change the reference to match the cell immediately beside your first name.
  4. Review the first result before filling. Check that the formula returned text in the expected row and did not change the source cell. PROPER converts text to title case: it capitalizes the first letter of each word and makes subsequent letters lowercase. It does not simply capitalize the first letter of the entire cell. This is usually useful for names entered inconsistently, but it cannot know every person’s preferred spelling.
  5. Copy the formula down the list. Select B2 and point to the small square at the lower-right corner of the selection, called the fill handle. Drag it down to the last row of names. If the source list is a continuous block with no blank rows, you can often double-click the fill handle to fill down alongside it. Check the final row afterward, because blank rows or neighboring data can make automatic filling stop early or extend farther than intended. On Mac and Excel for the web, the fill handle is also available; dragging it is a straightforward option.
  6. Check the converted column against the source. Scan several entries from the top, middle, and bottom, not just the first formula result. Check names with spaces, hyphens, apostrophes, initials, accents, and unusual casing. PROPER may convert a preferred spelling such as McDONALD to Mcdonald, and it may not format every compound surname according to that person’s preference. Correct exceptions in the output column manually after you finish checking the formula results.
  7. Decide whether the results should remain formulas. If you want the output to update when the original names change, leave the formulas in place. If you need a fixed list, select the completed output cells and copy them. Then use Home > Paste > Values to paste the displayed text over the formulas, or into another destination. Confirm that the pasted cells contain names rather than formulas before deleting or changing the source column. Excel for Mac and Excel for the web also provide a Values paste option from the Home tab or paste menu.
  8. Replace the original column only after confirming the values. If another workbook, report, or process depends on the original column, keeping the formatted names in their own column may be safer. If you must replace the source, first make sure you have a recoverable copy, then paste the converted results as values into the source location. Check a few cells again after pasting, and remove the temporary column only when you are satisfied with the final list.

To make every letter uppercase instead of using conventional name capitalization, put names in A2:A20 and the output in B2, then use =UPPER(A2). For example, jane smith becomes JANE SMITH. That is a different result from title case, and it is not usually the standard way to display personal names. Use PROPER when you want Jane Smith.

Common Mistakes

  • Expecting PROPER to know a person’s exact name styling. The function follows a general text rule, not a name dictionary. It may change McDONALD to Mcdonald, format a short particle unexpectedly, or alter an intentionally lowercase element. Review the finished list and manually correct names when the person’s preferred spelling is known.
  • Confusing title case with all capitals. PROPER makes the first letter of each word uppercase and the rest lowercase. It will not produce SMITH, JANE. Use UPPER if all letters genuinely need to be uppercase, or adjust the data for a different format you have been asked to use.
  • Typing the formula over the source name. A formula that refers to the cell you just replaced can create a circular reference or erase the original text. Enter the formula in a separate blank column, then copy and paste values only if replacement is necessary.
  • Filling too far or not far enough. Dragging the handle past the list can create formulas beside unrelated rows, while a blank row can cause double-click autofill to stop early. Set the last row deliberately and inspect the bottom of the results before using them.
  • Removing formulas without keeping their displayed results. If you delete the source cells while the output formulas still refer to them, the output may change or show an error. First copy the output and paste values, then verify those values before removing the original data.
  • Assuming capitalization cleans every data problem. PROPER does not remove leading spaces, combine duplicate records, or verify whether a name is spelled correctly. It changes capitalization only; inspect and clean other issues separately.

Tips

  • Keep a source column during review. Comparing the original and formatted versions side by side makes unusual changes easier to spot. You can hide the source later if the finished sheet needs to look simpler, rather than deleting it immediately.
  • Use a table for a list that will grow. If you convert your range to an Excel table with Insert > Table, a formula entered in the results column may fill through the table column automatically. When new table rows are added, Excel can carry that calculated-column formula into them. Still check the new results, especially when future entries use special name conventions.
  • Clean extra spaces when needed. If a name has accidental spaces at the beginning, end, or between words, you can combine TRIM with PROPER. With names in A2:A20 and the result starting in B2, enter =PROPER(TRIM(A2)). For example, TRIM removes extra ordinary spaces around or between words before PROPER applies capitalization. It does not remove every kind of invisible character, such as some nonbreaking spaces copied from web pages.
  • Keep the formula simple when the list is already clean. For ordinary entries with one or more words, =PROPER(A2) is enough. There is no need to use a more complex formula if the only requested change is capitalization.
  • Label the output column clearly. A heading such as Formatted Name or Title Case Name helps anyone opening the workbook understand that the column was transformed. If the workbook is shared, note whether the result remains formula-driven or has been pasted as fixed values.
  • Use the right method for a one-off list. For a small number of names, you can type corrections manually. For a long or frequently updated list, the formula is more consistent and easier to repeat. Either way, verify special cases instead of assuming that uniform formatting equals correct spelling.

Troubleshooting

The formula appears as text instead of a result. Check whether the cell is formatted as Text or whether an apostrophe was entered before the equals sign. Change the cell format to General, re-enter the formula, and press Enter. If Excel displays the formula in the cell rather than its result across the worksheet, check whether Show Formulas is enabled on the Formulas tab and turn it off.

The formula returns an error or refers to the wrong row. Confirm that the reference points to the source name beside the formula. If your first name is in A2, the first output formula should refer to A2, not the header in A1 or an unrelated cell. If the original range has been moved, update the reference or create the formula again beside the correct source row.

Some names have the wrong capitalization. This is a limitation of automatic title casing, not necessarily a formula failure. Correct those output cells manually after the formula is filled. If the output must remain dynamic, a manual correction can be replaced the next time the formula recalculates; for a final fixed list, copy the results and paste values before applying corrections.

Spaces or odd characters remain. PROPER changes capitalization but does not perform full text cleanup. Try TRIM for ordinary extra spaces as shown above. If text was copied from a website or another system, a nonbreaking space or other invisible character may remain; inspect and clean that source text separately before relying on the formatted output.

The fill handle is missing or does not fill the range. Make sure you are pointing to the lower-right corner of the selected cell and that editing or worksheet protection is not preventing changes. If dragging is awkward, copy the first formula cell, select the remaining destination cells, and use Home > Paste. Confirm the selected range before pasting so you do not overwrite unrelated data.

Values paste did not replace formulas. Re-select the output range and use the Values option under Home > Paste. If you paste into a different column, ensure that destination is large enough and does not contain data you need. Click a pasted cell and inspect the formula bar: a fixed text result should display the name, not a formula beginning with an equals sign.

Frequently Asked Questions

Does PROPER capitalize the first letter of every word?
Yes. It converts each word to title case by making its first letter uppercase and the following letters lowercase. It changes the whole cell, so unusual spelling may need manual adjustment.

Can I capitalize names in the same column?
Not safely with a formula that refers to the same cell, because that creates a circular reference. Use a helper column first, check the results, copy them, and paste values into the original column only if you are sure you want to replace the source.

How do I make every letter in each name uppercase?
Use UPPER in a separate column. With the original text in A2 and the output in B2, =UPPER(A2) returns all letters in uppercase. This is different from conventional title-case formatting.

Will PROPER preserve names such as McDonald or O’Neil?
It commonly produces O’Neil, but it can change mixed-case names such as McDonald to Mcdonald. It applies text rules rather than checking a list of personal names, so verify compound names and preferred spellings individually.

Will this work in Excel for Mac or Excel for the web?
Yes. PROPER and the same formula syntax work in current Excel for Mac and Excel for the web. The ribbon layout can differ slightly, but you can enter the formula in a neighboring cell and fill it down in either version.

Can I format a name list without a formula?
For a few names, you can edit each cell manually. For a long list, PROPER is faster and gives consistent general capitalization. Because it cannot determine each person’s preferred styling, plan to review exceptions either way.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.