Excel Proper Case for Names: Formula and Limits

Formulas & functions · Updated November 19, 2026

To put names in proper case in Excel, use the PROPER function: with the original name in A2, enter =PROPER(A2) in another cell and fill the formula down. It changes text such as “jANE DOE” to “Jane Doe,” but it does not know a person’s preferred or legally correct spelling, so review names with unusual capitalization before replacing the originals.

What proper case means in Excel

Proper case is a text style in which the first letter of each word is uppercase and the remaining letters are lowercase. Excel’s PROPER function applies that pattern to text; it is a transformation, not a name dictionary or a spelling checker. It can be useful when a list has been imported from a form, copied from another system, or typed inconsistently.

For example, if A2 contains “mARIA gARCIA,” the formula returns “Maria Garcia.” If A2 contains “alex smith,” it returns “Alex Smith.” This is different from making every letter uppercase with UPPER or every letter lowercase with LOWER. Those functions also change case, but neither produces title-style capitalization.

Proper case is often a convenient first pass for customer lists, mailing labels, attendee rosters, and similar data. It is not a guarantee that the result is the correct form of someone’s name. Keep that distinction in mind whenever the data will be used in official records or communications.

How the PROPER function works

PROPER takes one text value or cell reference. It capitalizes the first letter in the text and letters that follow characters Excel treats as separators, then changes other letters to lowercase. Spaces and many punctuation marks can therefore create a new capitalized segment. Numbers and punctuation remain in the result, but they can affect which following letters are capitalized.

With the name in A2, =PROPER(A2) converts “lee ANN” to “Lee Ann.” It also changes “O’NEIL” to “O’Neil” and “ANNE-MARIE” to “Anne-Marie.” The result follows Excel’s general text rule; it does not infer that a person might prefer “O’Neil,” “Anne-Marie,” or a different styling.

The function returns text in the formula cell and leaves the source cell unchanged. That makes it possible to compare the source and result side by side before deciding whether to use the converted version. If the referenced cell is empty, the result is an empty string.

Apply proper case to a column

  1. Keep the original names in one column, for example A2:A100, and leave an adjacent column available for the results.
  2. With the name in A2, enter =PROPER(A2) in B2 and press Enter.
  3. Select B2 and use the fill handle at the lower-right corner of the cell to fill the formula down the list. Excel adjusts the reference for each row.
  4. Review the converted names against the originals, correcting exceptions manually where needed.
  5. If the cleaned names should replace the originals, copy the result cells, select the destination, and choose Home > Paste > Values. This pastes the displayed text rather than formulas that still point to the source column.

For a formatted Excel table, entering the formula in the first row of a new table column will generally fill the calculated column automatically. Check that the formula has reached all rows, especially if the table contains blank rows or if automatic formula filling has been disabled. On Mac, the same formula and ribbon approach are available in Excel for Microsoft 365; ribbon labels can vary slightly with window size or updates.

Examples with first and last names in separate columns

When first and last names are already in separate cells, you can join them and apply proper case in one formula. With the first name in A2 and the last name in B2, enter =PROPER(TRIM(A2&" "&B2)) in C2. If A2 contains “JANE” and B2 contains “DOE,” C2 returns “Jane Doe.” The space between the references separates the names, and TRIM removes extra ordinary spaces at the beginning or end of the combined text.

This approach is useful for presentation, but it assumes that joining the two fields with one space is appropriate. It will not preserve a middle name unless that field is included, and it cannot determine whether a surname has multiple words or a preferred prefix. If the sheet has a middle name in C2, for example, a formula can combine all three fields; however, blank fields may need a more tailored approach if you do not want extra separators.

If the full name is already in one cell, use the simpler single-cell formula. Splitting a name into first and last components is not always reliable: names can have multiple given names, compound surnames, particles, or different naming conventions. Do not split a complete name just to apply capitalization unless the data structure genuinely requires separate fields.

Common name capitalization problems

The main limitation is that people’s names do not all follow the usual pattern of one uppercase initial followed by lowercase letters. For instance, applying PROPER to “MCDONALD” produces “Mcdonald,” while “MCDONALD” may be the person’s chosen spelling. “MCKAY” becomes “Mckay,” and “VAN DER WAALS” becomes “Van Der Waals,” even though the preferred capitalization of a prefix may differ.

Initials can also be changed. “J R R TOLKIEN” becomes “J R R Tolkien,” not a version with periods. A form such as “DJ” may become “Dj,” and a brand or organization name with internal capitals can lose that styling. A hyphenated or apostrophized name can be capitalized at the character after the punctuation, which may or may not match the person’s preference.

Other practical issues are unrelated to capitalization. Imported text may contain leading or trailing spaces, repeated spaces, line breaks, or nonbreaking spaces. PROPER changes letter case; it does not comprehensively clean every kind of hidden or irregular whitespace. A visible difference between two names may therefore remain even after both have been converted.

Use the converted column as a proposed cleanup, not unquestioned truth. For a small list, compare every row. For a large or important list, preserve the original data and verify exceptions with a trusted source or the people concerned.

Clean extra spaces before changing case

For ordinary extra spaces, combine TRIM with PROPER. With the original text in A2, enter =PROPER(TRIM(A2)) in B2. If A2 contains “ JANE DOE ”, the result is “Jane Doe”: leading and trailing ordinary spaces are removed and repeated ordinary spaces between words are reduced to one.

Some copied data uses a nonbreaking space, which can look like a normal space but is not removed by TRIM alone. With the imported name in A2, enter =PROPER(TRIM(SUBSTITUTE(A2,CHAR(160)," "))) in B2 to replace character 160 with a regular space, trim ordinary extra spaces, and then apply proper case. This handles that particular character; it is not a universal cleanup formula for every possible imported character.

As with any cleanup, inspect the result before pasting values over source data. If text came from a web page or an external database, retain a copy of the raw import so an unexpected change can be traced or reversed.

Choose between a formula and manual correction

A formula is a good choice when you have many rows and want consistent, repeatable formatting. It is also easy to update: if a source name changes, the formula result updates automatically. That can be helpful while reviewing a dataset, but it also means the output column depends on the source column until you paste values.

Manual correction is often better for a short list or a list containing many known exceptions. You can use PROPER to create a starting point and then edit individual results. If you need to maintain both a standard display name and a person’s preferred spelling, store those as separate fields instead of repeatedly applying a general capitalization rule.

Excel’s Flash Fill can recognize a pattern from examples and complete similar entries. It can be useful when the desired result includes exceptions or a specific layout, but it may not infer your intention correctly from too few examples. Review the output just as you would review formula results. For a simple capitalization-only task, PROPER is usually more transparent because its rule is visible in the formula.

Keep formulas or replace them with values

Whether to keep the formula depends on how the cleaned data will be used. Keep formulas when the source column will continue to change and you want the formatted column to update. Use values when the destination should be a fixed, independent list, or when you are preparing a final export that should not contain formulas referring to other columns.

To make a fixed copy, select the formula results, copy them, and use Home > Paste > Values in the target cells. Confirm that the pasted names are correct before deleting or overwriting the originals. Pasting values removes the formula relationship, so later changes to the source will not update the pasted names.

Another safe workflow is to keep the raw import on one worksheet and place cleaned values on another. That preserves an audit trail and makes it easier to revisit unusual spellings. If several people use the workbook, label the columns clearly—for example, “Imported name” and “Formatted name”—so no one mistakes an automatic formatting result for a verified preferred name.

Frequently Asked Questions

What is the Excel formula for proper case?
With the text to format in A2, enter =PROPER(A2) in another cell. Fill the formula down to apply it to more rows. The source cell is not changed unless you later replace it with the result.

Can Excel capitalize every word in a name?
PROPER capitalizes letters after word-separating characters according to its text rule, so it often capitalizes each space-separated word. Punctuation can also affect the result, and the function does not know the correct capitalization of a particular person’s name.

How do I change names to proper case without a formula?
You can type examples in the desired format and try Data > Flash Fill, then inspect the completed column. You can also edit a small number of names manually. Flash Fill is pattern-based, so it can make an incorrect guess when the examples do not make the intended pattern clear.

Why does PROPER change McDonald or O’Neil?
The function applies a general capitalization rule rather than checking a list of surnames. It changes letters that are not at the beginning of a word to lowercase, and punctuation can mark a new word segment. Correct unusual spellings manually or keep a verified preferred-name field.

Can I use PROPER to correct spelling mistakes?
No. It changes capitalization, not spelling, identity, or name order. “Jhon” remains “Jhon” with the first letter capitalized; Excel cannot determine from the formula that the intended spelling might be “John.”

Will PROPER remove extra spaces?
No. It changes capitalization but does not remove repeated spaces. With the text in A2, use =PROPER(TRIM(A2)) to handle ordinary leading, trailing, and repeated spaces before applying the case change.

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.