Excel Formula to Capitalize Names: What PROPER Gets Right

Formulas & functions · Updated November 20, 2026

To capitalize names in Excel, enter =PROPER(A2) in a helper column when the name is in A2. PROPER changes text to title-style capitalization, such as turning “jANE DOE” into “Jane Doe”; check the results because many names, acronyms, and cultural naming conventions do not follow that pattern.

The formula for capitalizing names

In Microsoft Excel for Microsoft 365, the standard formula is PROPER. With a name in cell A2, enter this in B2:

With the name “jANE DOE” in A2, =PROPER(A2) returns “Jane Doe”.

The formula reads the text in A2 and returns a capital letter at the start of each word, with the other letters in that word changed to lowercase. It does not edit A2 itself. Keeping the formula result in another column lets you compare the original with the formatted version before deciding whether to replace anything.

PROPER is useful when a list has inconsistent capitalization—for example, names imported from a form where people typed in all caps, all lowercase, or a mixture. It is not a guarantee that the result matches each person’s preferred or conventionally correct spelling.

What PROPER does—and what it does not do

PROPER applies a general text rule; it does not recognize people, surnames, languages, or a company’s chosen brand spelling. It can make a column visually consistent, but it cannot infer whether a name should use an internal capital, a lowercase particle, or an all-capital abbreviation.

For example, the formula typically changes “MARY ANN JONES” to “Mary Ann Jones” and “john smith” to “John Smith.” That is often what a directory needs. But it can also turn “NASA” into “Nasa,” “iPhone” into “Iphone,” and “McDONALD” into “Mcdonald.” Those results follow the capitalization rule rather than the preferred spelling of the acronym, product, or surname.

PROPER is not the same as changing a cell’s font, applying a number format, or choosing a capitalization option in a menu. The output is new text returned by a formula. If the source cell changes, the formula result updates too, unless you later replace it with a fixed value.

Apply the formula to a whole name list

For a list with names in A2:A100, use a neighboring column for the cleaned results. In B2, with the name in A2, enter =PROPER(A2). The result for “ELENA GARCIA” in A2 is “Elena Garcia”. Then fill the formula down the rest of column B.

  1. Insert or select an empty column beside the original names, and label its heading something clear, such as “Capitalized name.”
  2. Enter the formula in the first data row, adjusting A2 if the name is in a different column or row.
  3. Press Enter and check the result against the source.
  4. Use the fill handle at the lower-right corner of the formula cell to fill down, or copy the cell and paste it into the remaining rows.
  5. Review exceptions before using the output for mail merges, reports, or an external system.

Excel adjusts the reference as the formula is filled: the next row will refer to A3, then A4, and so on. The formula works in Excel for Microsoft 365 on Windows, Mac, and the web. The interface for filling or copying cells may look different on Mac or in a browser, but the formula itself is the same.

Combine first and last names in separate columns

If first names are in column A and last names are in column B, you can join the two cells and capitalize the combined text. With the first name in A2 and the last name in B2, enter this in C2:

With “AVA” in A2 and “PATEL” in B2, =PROPER(A2&" "&B2) returns “Ava Patel”.

The ampersands join the first name, a space, and the last name. This is convenient for creating a display-name column while preserving the original fields. If the source data may have extra spaces, you can wrap the joined text in TRIM. With the first and last names in A2 and B2, =TRIM(PROPER(A2&" "&B2)) returns “Ava Patel” for the same example and removes extra spaces at the ends or repeated spaces between words.

Joining cells this way is best for a simple first-name/last-name layout. It does not determine name order for different cultures or handle every possible structure, such as multiple family names, suffixes, or a surname with a space. Keep the separate source columns if you may need to sort, address, or export the parts independently.

Names that need a manual check

Many names have correct spellings that do not match the general “first letter uppercase, rest lowercase” rule. Some surnames use internal capitals, such as McDonald or MacLeod; some people write their names with a lowercase initial; and some organizations deliberately use mixed-case styling. A formula cannot know which spelling is right from the letters alone.

Particles and prefixes are another common exception. Depending on the person, language, and context, parts such as “de,” “van,” “von,” or “al” may be capitalized differently. PROPER may turn “van der Waals” into “Van Der Waals,” even when the preferred form is “van der Waals.” Apostrophes and hyphens can also produce a result that needs review, particularly when a person’s chosen form differs from the rule Excel applies.

For dependable records, use an authoritative source—such as the person’s own submission or an approved organization directory—to verify exceptions. Do not assume that every surname should be converted to title case just because most names in a list look better that way. If a name is used in legal, customer, or identity records, preserving the original spelling and checking with the appropriate source is safer than silently changing it.

Leave empty rows empty and preserve the source

Applying PROPER to an empty cell returns an empty-looking result, but a helper formula can make the intention explicit and is useful if the source column contains formula-generated empty strings. With a name in A2 and the formula in B2, enter =IF(A2="","",PROPER(A2)). If A2 is blank, the result is blank; if A2 contains “JORDAN LEE,” the result is “Jordan Lee”.

For large lists, keep the original data until you have reviewed the output. One practical approach is to retain the source column, create a formatted column, and filter or scan for cases that need attention. This also makes it possible to correct the source and let the formula update rather than losing the original spelling.

When the reviewed results need to become fixed text—for example, before sending a workbook to a system that does not support formulas—copy the result column and use Home > Paste > Values. This replaces the formulas with their current displayed results. Do this only after checking the exceptions, and keep a copy of the original data if you may need to restore it.

PROPER compared with other ways to change capitalization

PROPER is the right choice when you want every word to receive title-style capitalization. Excel also has UPPER and LOWER functions, which change all letters to uppercase or lowercase, respectively. They are useful for standardizing codes or creating a comparison column, but neither produces name-style capitalization. Neither function can identify the correct case for a person’s name.

Flash Fill can recognize a pattern from examples and fill a column, which can be useful when the desired result includes exceptions that a simple formula cannot express. Enter one or more corrected examples beside the source, then use Data > Flash Fill in Excel for Microsoft 365 on Windows. Flash Fill is a pattern-based convenience, not a reliable substitute for reviewing names; it may not infer a complex pattern correctly from limited examples. Mac and web availability and controls can differ, so use the formula when you want a predictable, recalculating result.

Manual editing is often the best option for a short list or for a list with many unusual spellings. For a long list with mostly ordinary capitalization, a formula saves time, while a review pass handles the exceptions. The useful distinction is not “formula or manual” for every row: it is using automation for the repetitive rule and a person or trusted record for details that require knowledge.

A reliable cleanup workflow

Before changing a name list, decide whether you want to standardize appearance or correct inaccurate source data. PROPER can do the first in bulk, but it cannot confirm identity or repair misspellings. A process that preserves the source and checks exceptions reduces the chance of turning a formatting task into a data-quality problem.

  • Make a copy of the workbook or retain the unmodified source column.
  • Apply PROPER in a separate column and check a sample from the top, middle, and bottom of the list.
  • Look specifically for acronyms, internal capitals, lowercase particles, hyphenated names, and unusual punctuation.
  • Verify flagged cases against a trusted source rather than guessing from a general capitalization rule.
  • Convert to values only if the finished text needs to be independent of the formula, and keep an original copy where appropriate.

This approach also makes the result easier to audit: another person can see what the input was, what Excel changed, and which records received a manual correction. If the source list is updated later, you can rerun the formula rather than retyping every name.

Frequently Asked Questions

What is the Excel formula to capitalize each word in a name?
Use PROPER with a reference to the cell. If the name is in A2, =PROPER(A2) returns title-style capitalization, such as “alex kim” becoming “Alex Kim”.

How do I capitalize names without changing the original column?
Put the formula in an empty column beside the source data and fill it down. The formula displays a separate result, leaving the original cell untouched. You can compare the two columns before deciding whether to keep the results.

Can Excel capitalize names and preserve acronyms such as NASA?
Not with PROPER alone. It converts “NASA” to “Nasa” because it does not recognize acronyms. Keep or restore the acronym’s correct form manually, or use a process that checks such exceptions against a known list.

Why did PROPER change McDonald or van der Waals?
PROPER follows a general capitalization pattern; it does not know a name’s preferred spelling or a language’s conventions. Review names with internal capitals and particles, then correct them using a reliable source.

How can I keep blank cells blank?
Use an IF check around PROPER. With the source in A2, =IF(A2="","",PROPER(A2)) returns an empty result when A2 is empty and capitalizes the text when it is not.

Can I replace the formulas with the names they display?
Yes. After reviewing the results, copy the formula cells and choose Home > Paste > Values. The cells will contain fixed text rather than formulas that recalculate from the original names.

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.