How to Format Proper Names in Excel with PROPER Function

To capitalize names in Excel, put this formula in a blank helper column beside the first name: =PROPER(A2). This assumes the original name is in A2; for example, JANE DOE becomes Jane Doe. Fill the formula down, review names that do not follow standard capitalization, then copy the corrected results and paste them as values if you want to replace the originals. PROPER is a useful starting point, but it cannot know every person’s preferred spelling.

The steps below are for Excel for Microsoft 365 on Windows. Keep the source column until you have checked the results; a separate output column makes it easy to compare and undo changes.

What You’ll Need

An Excel workbook with names stored as text in one column, such as A2:A100. Ideally, use one name per cell or one full name per cell.
A blank column for the formula results. If the workbook contains important data, save a separate copy before making bulk edits.
A short list of exceptions to check, especially names with internal capitals, unusual capitalization, or a spelling supplied by the person themselves.

Step-by-Step

Check how the names are arranged. Find the column containing the names and confirm that each row contains the value you intend to format. A full name in one cell can be formatted as a whole. If first and last names are already in separate columns, format each column independently. Make sure the cells are not mixed with headings or notes that should not be changed. If there is a header in row 1, start with the first data row, such as row 2.
Add a helper column. Insert or select an empty column beside the source names and give it a clear heading, such as Formatted Name. Using a helper column preserves the original spelling while you inspect the output. Do not enter the formula over the source names at this stage: a formula that refers to a cell you overwrite can lose its input or create a circular reference.
Enter PROPER in the first result row. With the original name in A2 and the helper column starting in B2, type =PROPER(A2) in B2 and press Enter. PROPER capitalizes the first letter of each word and makes the other letters lowercase. For example, JANE DOE becomes Jane Doe, and john smith becomes John Smith. It also treats many punctuation marks, such as spaces and hyphens, as word boundaries, so jean-luc can become Jean-Luc.
Fill the formula down. Select the formula cell and drag the small square at its lower-right corner down to the last row. You can also double-click that square when the neighboring source column has continuous data; Excel fills down alongside it. Check that the final formula points to the corresponding row—for example, B3 should refer to A3, not A2. If the range is an Excel table, entering the formula in the first row of the new table column will usually fill the calculated column automatically.
Clean up extra spaces if needed. PROPER changes capitalization but does not remove leading, trailing, or repeated spaces. For ordinary extra spaces, you can use a formula that combines TRIM with PROPER. With the source name in A2, enter =PROPER(TRIM(A2)) in the helper column. For example, a cell containing three spaces before JANE, two spaces between JANE and DOE, and a trailing space returns Jane Doe. TRIM removes leading and trailing spaces and reduces repeated standard spaces to one.
Handle nonbreaking spaces when TRIM does not help. Names pasted from a website or another system may contain nonbreaking spaces, which look like regular spaces but are not removed by TRIM alone. With the source name in A2, use =PROPER(TRIM(SUBSTITUTE(A2,CHAR(160)," "))) in the helper column. This replaces character 160 with an ordinary space before trimming and capitalizing. For example, if JANE and DOE are separated by a nonbreaking space and the cell has no other unusual characters, the result is Jane Doe. If the result still looks wrong, check for other invisible characters in the source.
Review names that need individual treatment. Compare the output with the source and any reliable spelling reference. PROPER changes every word into a general title-case pattern; it does not recognize a person, language, organization, or naming convention. It will turn MCDONALD into Mcdonald, not McDonald, and may change a name such as DE LA CRUZ to De La Cruz even when the person uses a different form. Check apostrophes, hyphens, particles such as van or de, initials, and names with internal capitals. Correct these exceptions directly in the output column.
Replace the source only after checking. When the results are correct, select the completed helper cells and copy them. Select the corresponding source cells, then choose Home > Paste > Values. This replaces formulas with their displayed text, so the corrected names will not depend on the helper column. Confirm the range before pasting and avoid including the header unless you intend to replace it. Keep a backup or the original column until you are satisfied with the result.
Remove the helper column if it is no longer needed. After pasting values and checking a few rows from the beginning, middle, and end, you can delete the helper column. If you prefer to retain the original names for auditing, keep both columns and label them clearly, for example Original Name and Standardized Name. Save the workbook once the final version is confirmed.

In Excel for the web, the PROPER formula works in the same way, and you can use the Home tab’s paste options to paste values. Excel for Mac also supports PROPER; ribbon wording and keyboard shortcuts can differ, so use the Paste Values option on the Home tab rather than relying on a Windows shortcut.

Common Mistakes

Assuming title case equals a person’s correct name. PROPER applies a general capitalization rule, not a name dictionary. It cannot infer that a person writes their name as McDonald, MacLeod, eBay, or another form with internal capitals. Treat the output as a draft that needs review, rather than an authoritative correction.
Running the formula directly over the original data. A formula needs the source value to remain available. Put results in a separate column first, and only replace the source after checking and pasting values.
Expecting capitalization to fix spelling or spacing in every case. PROPER does not correct misspellings, remove all kinds of invisible characters, or decide whether two words should be joined. Use TRIM for standard extra spaces and SUBSTITUTE for nonbreaking spaces, then investigate anything still inconsistent.
Including a header or unrelated rows in the fill. Starting in the header row may turn a label such as FULL NAME into Full Name. Check the first and last rows of your selected range before filling or pasting.
Overlooking initials and abbreviations. An entry such as J R R TOLKIEN may become J R R Tolkien, which may be acceptable, but abbreviations like USA or a credential such as PhD can become Usa or Phd. Restore the expected capitals manually.

Tips

Keep an untouched copy of the source names until the review is finished. This is especially helpful when a list came from a customer database, registration form, or imported file.
Use filters or sorting to make review easier. For example, scan for names with hyphens or apostrophes, and compare the original and formatted columns side by side. A formula can standardize a pattern, but human review is the dependable way to preserve individual preferences.
If you routinely receive names in all caps, consider adding a separate standardized-name field to your process rather than changing the original record. This makes the transformation transparent and lets staff compare both versions.
For a small list, it may be quicker and safer to correct a handful of exceptions by typing into the helper cells. For a large list, keep an exception list and check it after each refresh instead of assuming every new row follows the old pattern.
Use PROPER only for text that should follow this style. It is not appropriate for every label or code: product names, acronyms, usernames, and organization names may have deliberate capitalization that the function will alter.

Troubleshooting

The formula appears as text instead of returning a name. The cell may be formatted as Text, or the formula may have a leading apostrophe. Change the cell format to General, edit the cell, and press Enter again. Confirm that the entry begins with an equals sign and that Show Formulas is not turned on (on Windows, Ctrl+` toggles formula display). On Mac, the shortcut differs; use Formulas > Show Formulas if available in your ribbon.

The result has the wrong capitalization for a particular name. This is expected when the name has an exception such as McDonald or a surname convention that PROPER cannot identify. Edit that result manually after the formula is filled. If you later refill the formula, it may overwrite your manual correction, so finish the fill first or keep exceptions in a separate review step.

Extra spaces remain. Check whether they are ordinary spaces or nonbreaking spaces. TRIM handles standard spaces; the SUBSTITUTE and CHAR(160) formula above handles the common nonbreaking-space character. If pasted data still contains odd gaps, inspect the source for other special characters and clean those separately.

Some rows stay blank or show an error. Verify that the formula references the correct source row and that the source cell contains the name. If you see an error, check for a damaged formula or a reference to a deleted column. If a cell contains multiple pieces of data, split or clean that source deliberately rather than expecting PROPER to interpret its structure.

Pasting values changes more than the intended names. Undo immediately with Ctrl+Z on Windows, then select only the output cells and their matching destination cells before choosing Home > Paste > Values. On Mac, use Edit > Undo or the Undo button. If the workbook has already been saved or closed, restore the original names from your backup or version history.

Frequently Asked Questions

Does PROPER capitalize every word in a full name?
It capitalizes the first letter of each word and lowercases the remaining letters, using punctuation and spaces as boundaries. That makes it useful for many full names, but it does not know each name’s conventional or preferred spelling.

Can Excel turn names into proper case without a formula?
Flash Fill can infer a pattern from examples: enter the desired version beside a few source names, then use Data > Flash Fill or Ctrl+E on Windows. Check the results carefully because it can infer a pattern incorrectly. On Mac, use Data > Flash Fill if the command is available in your Excel version; the Windows shortcut may not apply.

Can I use PROPER on names in separate first- and last-name columns?
Yes. If first names are in A2:A100 and surnames are in B2:B100, create a separate formatted column for each, using the relevant source cell in each formula. This keeps the fields separate and makes it easier to preserve a suffix, middle name, or other part of the record.

Will PROPER preserve names like McDonald or O’Neill?
It may format O’Neill as expected because the apostrophe separates word parts, but it will generally turn MCDONALD into Mcdonald. Do not rely on automatic formatting for names with special capitalization; compare them with the spelling the person or organization uses.

How do I keep the results after deleting the formula column?
Copy the formula results and paste them into the destination using Home > Paste > Values. The pasted cells contain text rather than formulas, so you can then remove the helper column without losing the names.

Does PROPER change names permanently?
No. A formula displays a transformed result while the original cell remains unchanged. The change becomes permanent in the destination only if you paste values over the original data or type the new spelling there. Keep an original copy when the exact source form matters.

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.