Proper Case in Excel: Change Names with the PROPER Function

Formulas & functions · Updated November 20, 2026

To change names to proper case in Excel, enter =PROPER(A2) in a blank column beside the first name, then fill the formula down. Excel will capitalize the first letter of each word and make the remaining letters lowercase. Keep the original names until you have checked the results; you can then copy the corrected column and paste it as values if you want to replace the source.

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.
  • A blank column for the results. Using a separate column protects your source data while you check the changes.
  • Access to the workbook to save your completed work. The PROPER function is also available in current desktop versions of Excel and Excel for the web.

Step-by-Step

  1. Check the layout and make a backup. Find the column containing the names and note its header and first data row. For example, if the header is in A1 and the first name is in A2, you can put results in B2. If the names are important or the workbook is shared, save a copy first with File > Save As. Do not include the header cell in the formula fill, because the header is text you want to keep as a label.
  2. Add a results column. Insert or use an empty column next to the names, and give its header a temporary label such as Proper Case. A separate output column lets you compare every converted name with the original. If another column already contains data, do not paste over it; choose a genuinely empty column or insert a new one using Home > Insert > Insert Sheet Columns.
  3. Enter the formula for the first name. With names in A2:A20 and the first result going in B2, select B2 and type =PROPER(A2), then press Enter. Excel displays the converted version of the value in A2. For example, if A2 contains jORDAN lee, B2 displays Jordan Lee. The formula refers to the original cell, so it does not alter A2.
  4. Fill the formula through the list. Select B2 again. Point to the small square at the lower-right corner of the selection, called the fill handle, and drag it down to the last row of names. Excel adjusts the reference for each row: B3 uses A3, B4 uses A4, and so on. If the adjacent column is populated continuously, you can also double-click the fill handle; check that Excel filled exactly as far as your name list.
  5. Review the converted names. Compare the result column with the source. Check especially for hyphens, apostrophes, prefixes, initials, and names with intentional internal capital letters. PROPER applies a general capitalization rule, not a list of personal-name conventions. If one result is unsuitable, you can correct that result manually after you convert the formulas to values, or keep the formula results in a separate column and make an edited final column.
  6. Turn formulas into fixed text if needed. If you want a finished column that will not change when the source changes, select the results, copy them with Ctrl+C, and choose Home > Paste > Values. This replaces the selected formulas with their displayed text. To replace the original names, copy the completed results, select the original name cells, and use Home > Paste > Values there. Confirm that the output is correct before replacing the source, and remove the temporary results column only after checking the pasted names.
  7. Save the workbook. Press Ctrl+S and, if the workbook is shared, make sure you are editing the intended file and sheet. If you need the original spellings for reference, keep a copy of the original column or save a separate backup rather than deleting it.

On Excel for Mac, the PROPER formula and fill-handle method work the same way. Use the Home tab’s Paste options to paste values; ribbon labels can vary slightly by version. On Excel for the web, enter the same formula and use the fill handle, then choose Home > Paste > Paste Values if you want fixed text. Keyboard shortcuts differ on Mac: use Command+C to copy rather than Ctrl+C, or use the ribbon paste options.

Common Mistakes

  • Typing the formula into the original name cell. A formula such as =PROPER(A2) entered in A2 refers to itself and can create a circular reference. Put it in a separate cell, such as B2, and point it to A2.
  • Including the header in the fill. If you start the formula in the header row, Excel may turn the heading into a formula result or create an unwanted entry. Start in the first row that actually contains a name.
  • Expecting PROPER to know a person’s preferred spelling. The function cannot infer that a particular name should retain an unusual capital letter or lowercase prefix. It applies the same mechanical rule to every entry, so review exceptions rather than assuming every output is correct.
  • Pasting formulas when you intended to paste text. A copied formula still depends on its source cell and can show a different result if moved or if the source is edited. Use Paste Values when you want a stable text result.
  • Overwriting other data by accident. Before pasting values into the original column, check the selected range and make sure it matches the result range. Keep a backup if the original capitalization may be needed later.

Tips

  • Use a table for a growing list. If the names are in an Excel table, add the formula in the adjacent table column. Excel often fills the calculated-column formula down automatically and applies it to new table rows. Verify the fill behavior in your workbook, especially if calculated columns have been disabled or customized.
  • Keep source and cleaned data separate. For mailing lists, reports, or imports, retaining the original column makes it easier to audit changes and correct exceptions. You can label the new field clearly, for example, Display Name.
  • Check leading and trailing spaces separately. PROPER changes capitalization but is not a general cleanup tool for extra spaces or inconsistent data. If spacing is a problem, inspect the affected rows or clean them in a separate step before treating the column as final.
  • Use the formula for repeatable updates. While the output remains a formula, changing A2 updates B2 automatically. That is useful when a list is still being edited. Convert to values only when you need a fixed snapshot or plan to remove the source column.
  • Think about the purpose of the names. Proper case is usually suitable for display, but it may not match how a person writes their name or the capitalization rules of an organization. Follow the source-of-truth spelling for official records rather than applying a blanket format without review.

Troubleshooting

The formula appears as text instead of a name. Check whether the cell is formatted as Text or whether a leading apostrophe was entered before the equals sign. Change the cell format to General, edit the formula (press F2, then Enter), and confirm that Show Formulas is not enabled. The Show Formulas command is on the Formulas tab; pressing Ctrl+` also toggles it in Windows Excel.

Every row shows the same name, or the results do not match the source. Inspect the first formula to confirm it refers to the correct source cell, such as A2 for the result in B2. When filling down, ordinary references should change by row. If you copied a formula that points to the wrong column or used an absolute reference such as $A$2, edit the first formula to use the intended cell reference and fill it down again.

Some results look wrong even though the formula works. This is usually a naming convention issue rather than an Excel error. PROPER lowercases letters that are not at the start of a word, so a name that deliberately uses an internal capital may not keep its preferred spelling. Correct those exceptions manually in a final values column, and preserve the unedited source until you have checked the full list.

Only part of the list was filled. Check the final row of the source range and compare it with the final row of the results. If the double-click fill handle stopped early because there are blank cells in the neighboring column, select the intended results range and drag the fill handle to the correct last row instead.

Paste Values is unavailable or the paste goes to the wrong place. First copy the formula results, then select the destination and open the Paste menu on the Home tab. Choose Values, not the regular Paste command. If the workbook is protected or the selected cells are part of a restricted range, you may need permission to edit them or need to paste into an unlocked column.

Frequently Asked Questions

What does proper case mean in Excel?

Proper case capitalizes the first letter of each word and makes other letters lowercase. Excel’s PROPER function applies this pattern to the text in a cell. It does not understand which capitalization a particular person, brand, or organization prefers.

Can I change names to proper case without a formula?

Excel does not have a standard ribbon command that converts selected text to proper case in place. The practical built-in method is to use PROPER in a helper column, review the result, and paste values where needed. This avoids losing the original data before you have checked the conversion.

Does PROPER work on a full name with spaces?

Yes. A formula such as =PROPER(A2) processes the full text in A2, including first and last names separated by spaces. It also capitalizes words in a multiword name, which is why prefixes and other special cases deserve a review.

Will PROPER preserve names such as McDonald or O’Neill?

Not reliably in every preferred form. The function follows character-based capitalization rules; it does not know that McDonald has an internal capital. Some apostrophe and hyphen cases may capitalize the following letter, but personal spellings still vary. Check these names against a trusted source and correct exceptions manually.

Can I apply proper case to an entire column?

Yes. Enter the formula beside the first data row and fill it down through the used rows. Avoid applying it to the header, and confirm the last result row aligns with the last name. For a continuously growing table, a calculated column can make future entries easier to format.

How do I keep the converted names but remove the formulas?

Copy the result cells, then use Home > Paste > Values to paste their displayed text. The names remain, but their links to the original cells are removed. Make sure you paste into the intended destination and retain a backup if you may need the original capitalization.

Related

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.