Excel Proper Case Formula: How PROPER Works in Cells

Formulas & functions · Updated November 18, 2026

In Excel for Microsoft 365, use =PROPER(A2) to convert the text in A2 to proper case: the first letter of each word is uppercase and the other letters are lowercase. For example, if A2 contains “jANE DOE,” the result is “Jane Doe.”

What Excel’s PROPER function does

PROPER is Excel’s built-in function for changing the capitalization of text. Its syntax is =PROPER(text), where text is the text or cell reference you want to convert. The function returns text; it does not alter the original cell’s contents.

Excel treats a word as a sequence of letters. It capitalizes the first letter and any letter that follows a character that is not a letter, then converts the remaining letters to lowercase. As a result, spaces and many punctuation marks act as word boundaries. With text in A2, =PROPER(A2) changes “hello, WORLD” to “Hello, World.”

This is useful for tidying imported names, city lists, headings, and other labels that have inconsistent capitalization. It is a capitalization rule, though, not a spelling checker or a system for recognizing names. Excel does not know whether a word is a person, company, acronym, or place.

Apply the formula to a column

To convert a list while keeping its original values available, put the formula in a neighboring column and fill it down. For example, with names in A2:A20, enter this in B2:

With the name “jANE DOE” in A2, enter =PROPER(A2) in B2; the result is “Jane Doe.”

  1. Insert a blank column beside the source text, if needed, and add a heading such as “Proper Case.”
  2. Enter =PROPER(A2) in the first result cell, adjusting A2 to the location of the first source value.
  3. Press Enter. Select the formula cell and drag its fill handle down the column, or double-click the fill handle when adjacent rows contain data.
  4. Check several results, especially names with punctuation, initials, or acronyms.

In an Excel table, a structured reference can make the formula easier to read. With a table column named Name, enter =PROPER([@Name]) in the corresponding table column; the formula applies to that row and normally fills through the calculated column. The exact column heading must match the table’s heading.

If you want to replace the source text after checking the results, copy the converted cells and use Home > Paste > Paste Values over the original cells. This replaces formulas with their displayed text. Keeping an untouched source column until you have verified the conversion is safer, because capitalization changes may not be reversible if the original values are overwritten.

What happens with punctuation and numbers

PROPER recognizes boundaries based on characters, not language rules or a dictionary. This often gives sensible results for common labels, but it can produce capitalization that looks wrong for a particular person or brand. A formula cannot infer every preferred spelling.

  • Apostrophes: With “o’NEIL” in A2, =PROPER(A2) returns “O’Neil.” That may not match a person’s preferred spelling, such as “O’Neil” or “O’Neil” with a different capitalization pattern.
  • Hyphens: With “ANNE-MARIE” in A2, =PROPER(A2) returns “Anne-Marie.” The letter after the hyphen is capitalized because punctuation separates words.
  • Initials and acronyms: With “NASA” in A2, =PROPER(A2) returns “Nasa.” PROPER lowercases the remaining letters, so it is not suitable for preserving all-capital abbreviations automatically.
  • Numbers and symbols: Digits and punctuation can separate letters and affect where the next letter is capitalized. Review codes, model names, and mixed letter-number identifiers rather than assuming the result matches their official styling.

Names such as “McDonald,” “van der Waals,” or “de la Cruz” are another reason to inspect results. PROPER applies its general rule; it does not know that a particular surname uses an internal capital or that a family prefers a lowercase particle. For high-stakes lists, confirm spellings against the people’s own records.

Clean extra spaces and imported text

Extra spaces can make a result look untidy or cause inconsistent entries. TRIM removes leading and trailing ordinary spaces and reduces repeated ordinary spaces between words to one. If A2 contains “ jANE DOE ”, use the following formula in B2:

With the messy text in A2, enter =PROPER(TRIM(A2)); the result is “Jane Doe.”

Text copied from websites or exported systems may contain a nonbreaking space, which can look like a regular space but is not removed by TRIM. CHAR(160) represents that character in many Windows-originated text exports. If A2 contains ordinary and nonbreaking spaces, use:

With the imported text in A2, enter =PROPER(TRIM(SUBSTITUTE(A2,CHAR(160)," "))). For example, an entry containing “ mARIA o’NEIL-smITH ”, with a nonbreaking space between the names, returns “Maria O’Neil-Smith.”

This cleanup formula handles that specific common spacing issue; it does not remove every possible invisible character. If imported data still looks inconsistent, inspect the source and identify the character involved before adding more substitutions. A formula that replaces characters indiscriminately can remove meaningful punctuation or spacing.

When PROPER is not the right choice

Proper case is a style, not a universal standard. It is commonly useful for display labels, but a particular organization may require names in uppercase, preserve brand capitalization, or follow a publication’s own style guide. Do not apply PROPER to every text column simply because some cells are inconsistent.

Avoid using it blindly on email addresses, URLs, passwords, product identifiers, abbreviations, or codes whose capitalization may matter. Even when a system treats a value as case-insensitive, converting its display text can make it differ from the original record. Keep identifiers unchanged unless the receiving system’s requirements are clear.

For personal names, decide whether a broad, consistent capitalization rule is acceptable or whether the original styling must be preserved. If a list is used for mailing, legal records, customer accounts, or publication, validate the converted values with an authoritative source. PROPER can make text visually consistent, but it cannot verify that a name is spelled correctly.

Alternatives for more control

If you only want to capitalize the very first character of a cell and leave the rest untouched, combine UPPER, LEFT, MID, and LEN. With the text in A2, enter =UPPER(LEFT(A2,1))&MID(A2,2,LEN(A2)) in B2. If A2 contains “hELLO WORLD,” the result is “HELLO WORLD,” not “Hello World.” This distinction matters: the formula changes only the first character, while PROPER changes the rest of the text to lowercase as well.

For repeatable cleanup of a large imported dataset, Power Query is another option in Excel for Microsoft 365 on Windows. Select the data and choose Data > From Table/Range to open the Power Query Editor. Select the text column, then choose Transform > Format > Capitalize Each Word. Review the preview before choosing Home > Close & Load. Power Query transforms the imported query output, rather than serving as a formula in each worksheet row; refresh the query when you need to process updated source data.

Power Query’s capitalization operation has the same broad limitation as PROPER: it does not understand each name’s preferred spelling. For a short list, a formula is usually straightforward. For a recurring import, a query may be easier to refresh. For exceptions such as acronyms or preferred brand styling, a correction list or manual review may be necessary.

Formula results, errors, and practical checks

PROPER normally returns text rather than a calculation, so it does not change a number into a numeric value. If the referenced cell is blank, the result appears blank. If the source contains a formula error, PROPER does not repair it; the error carries through. If the source cell contains a number, Excel converts it to text as part of the text operation, so avoid using the result column for numeric calculations.

Before using converted values in another system, check a representative sample and scan for exceptional patterns. Useful checks include acronyms, hyphenated names, apostrophes, multiple-word surnames, accented characters, and empty cells. The function handles ordinary English text predictably, but language-specific casing rules and unusual characters can require a more specialized review.

Formula names and argument separators can vary with Excel’s language and regional settings. The examples here use English function names and commas, as in Excel for Microsoft 365 on Windows. Excel for Mac and Excel for the web also support PROPER; the formula’s basic behavior is the same. Depending on regional settings, a local installation may display translated function names or use a different argument separator.

Frequently Asked Questions

What is the proper case formula in Excel?
Use =PROPER(A2) when the text to convert is in A2. It capitalizes the first letter of each word and makes the other letters lowercase.

How do I apply proper case to an entire column?
Enter =PROPER(A2) beside the first source value, then fill the formula down alongside the rest of the list. Review the results, and use Paste Values if you need to replace formulas with fixed text.

Can Excel PROPER preserve acronyms such as NASA?
No. PROPER turns “NASA” into “Nasa.” Preserve acronyms by correcting those results manually or by using a separate exception list or a more tailored process.

Does PROPER change the original cell?
No. It returns a converted result in the cell containing the formula. The source stays unchanged unless you deliberately replace it, for example by copying the results and pasting values over the source.

How do I capitalize only the first letter of a cell?
Use =UPPER(LEFT(A2,1))&MID(A2,2,LEN(A2)) when the text is in A2. This capitalizes the first character and leaves the remaining characters as they were; it does not capitalize the start of every word.

Does the PROPER formula work in Excel for Mac and the web?
Yes. PROPER is available in Excel for Microsoft 365 on Windows, Mac, and the web. Regional settings may affect the function name or argument separator shown in a localized installation.

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.