PROPER Function in Excel: Examples and Tips

Excel’s PROPER function capitalizes the first letter of each word and changes the remaining letters to lowercase. For example, if A2 contains jANE DOE, enter =PROPER(A2) in another cell to return Jane Doe; the original value stays unchanged.

What the PROPER function does

PROPER is a text function used to standardize capitalization. It is especially useful when names, places, or labels have been typed inconsistently—for example, one entry in all capitals and another in lowercase. The function returns a transformed text result that you can use in a report, export, or cleaned copy of your data.

Excel describes PROPER as making the first letter in each word uppercase and all other letters lowercase. In practice, punctuation and spaces can mark word boundaries too. That means the result is not the same as applying a language-aware name editor: it follows a general capitalization rule, not a person’s preferred spelling or every style convention.

For example, PROPER turns NASA into Nasa and iPhone into Iphone. Those results are mechanically consistent with the function’s rule, but they are not necessarily the correct way to write an acronym or brand. Review the output when the exact spelling matters.

PROPER syntax and a basic example

The function has one required argument: the text you want to convert. You can supply a cell reference or text directly. A cell reference is usually more practical because the result updates when the source cell changes.

With the unformatted name jANE DOE in A2, enter this formula in B2. The layout assumes A2 contains the source text; the formula returns Jane Doe.

=PROPER(A2)

To use the function, select the result cell, type the formula, and press Enter. To apply it to more rows, drag the fill handle—the small square at the lower-right corner of the selected cell—down the column. Excel adjusts the reference for each row, so the formula copied to B3 refers to A3.

You can also enter a short phrase directly in a formula. With no worksheet layout required, =PROPER("quarterly sales report") returns Quarterly Sales Report. For ongoing work, however, keeping the text in a cell makes it easier to edit and reuse.

Practical PROPER formula examples

These examples show common uses and the kind of output to expect. Each formula is intended for a separate result cell so that the original text remains available for comparison.

Standardize a name: With jAMIE PARKER in A2, enter =PROPER(A2). The result is Jamie Parker.
Format a location: With NEW ZEALAND in A2, enter =PROPER(A2). The result is New Zealand.
Join first and last names: With jAMIE in A2 and pATEL in B2, enter =PROPER(A2&" "&B2). The result is Jamie Patel. The ampersands join the two cell values with a space between them.
Convert a hyphenated label: With west-side OFFICE in A2, enter =PROPER(A2). The result is West-Side Office. PROPER can capitalize a letter after punctuation, so check hyphenated terms against your chosen style.

These examples also reveal an important limitation: PROPER changes capitalization, not meaning or spelling. It will not correct a misspelled name, add a missing space, or determine whether a word should stay lowercase in a particular title.

Clean extra spaces before changing case

PROPER does not remove unwanted spaces. If a cell contains leading or trailing spaces, the result generally retains them; repeated spaces between words remain repeated too. That can cause confusing comparisons or make a cleaned column look uneven.

With A2 containing the text with extra spaces shown here—two spaces before sOUTH, three between sOUTH and AMERICA, and one at the end—enter the formula below in B2. It returns North America with leading and trailing spaces removed and internal repeated ordinary spaces reduced to one.

=PROPER(TRIM(A2))

TRIM is helpful for ordinary spaces, but it does not remove every character that looks like a space. Data copied from a web page may contain a nonbreaking space. With that kind of character in A2, this formula first replaces character 160 with a regular space, then trims and capitalizes the result:

=PROPER(TRIM(SUBSTITUTE(A2,CHAR(160)," ")))

For example, if A2 contains north, followed by a nonbreaking space, then america, the formula returns North America. This cleanup is useful for imported text, but it does not remove all possible invisible characters; unusual source data may need additional inspection.

Handle blanks and preserve the source data

A formula referring to an empty cell can produce an empty-looking result. If you want an explicit blank check before converting, use an IF formula. With source text in A2 and the formula in B2, the result is blank when A2 is blank; if A2 contains mARIA, the result is Maria.

=IF(A2="","",PROPER(A2))

For a full column, put the formula in the first result row and fill it down. Keeping the original and transformed columns side by side is safer than overwriting the source, because you can spot unusual names and reverse a mistaken cleanup more easily.

When you need fixed text rather than formulas, copy the result cells and choose Home > Paste > Paste Special > Values. This replaces the formulas in the destination with their current displayed results. Confirm that the values look right before removing or replacing the source column.

Common problems and limitations

The most frequent surprise is that acronyms and brand names lose their intended capitalization. PROPER applies the same rule to every word; it does not know that NASA should remain uppercase or that a brand may use an unusual internal capital. Use it as a first pass, then correct exceptions manually or with a separate mapping table if those terms occur repeatedly.

Names also do not all follow standard title capitalization. A surname, prefix, or particle may have a conventional spelling that PROPER cannot infer. Apostrophes and hyphens can produce capitals after punctuation, which may be right for some names and wrong for others. Treat the formula output as a formatting suggestion, not a verification of a person’s identity or preferred spelling.

Other practical points to keep in mind include:

It does not fix typos: jan smth becomes Jan Smth, not a corrected name.
It does not clean all whitespace: combine it with TRIM for ordinary extra spaces, and investigate nonbreaking spaces in imported data.
It returns text: PROPER is intended for text formatting, not numeric calculations. Keep dates, quantities, and identifiers in an appropriate data type instead of applying capitalization blindly.
It is not a grammar tool: It capitalizes words mechanically and does not apply sentence case, title style, or language-specific editorial rules.

PROPER compared with other ways to change case

Excel’s other case functions serve different purposes. UPPER converts letters to uppercase, while LOWER converts letters to lowercase. PROPER applies its initial-capital rule. None of these functions understands a person’s preferred spelling or automatically preserves every acronym, so the right choice depends on the desired output.

If you only need to correct a few cells, editing them directly may be faster and more accurate. For a long column with many exceptions, a lookup table of known corrections can be more dependable than repeatedly repairing formula results. Flash Fill can also infer a pattern from examples: on Windows, enter a few desired results and use Data > Flash Fill. Check the generated values, because pattern recognition may not handle every variation consistently.

For repeatable data preparation, keep a source column, a formula-based cleaned column, and—where needed—a reviewed final column. That makes the rule visible and lets another person distinguish automatic formatting from human-approved corrections.

Frequently Asked Questions

How do I capitalize the first letter of every word in Excel?
Use PROPER on the cell containing the text. If the text is in A2, enter =PROPER(A2) in another cell. It capitalizes each word according to Excel’s general rule and lowercases the other letters.

Can PROPER capitalize only the first letter of a sentence?
No. PROPER capitalizes the first letter of each word, not just the first word in a sentence. It is therefore not a sentence-case function. For a sentence, use another method or edit the result to match the capitalization you need.

Why did PROPER change NASA to Nasa?
Because PROPER applies the same capitalization pattern to all words and does not recognize acronyms. Correct the acronym after conversion, or use a separate exception list when the same terms appear regularly.

Does PROPER remove extra spaces?
No. Use TRIM with PROPER if you want to remove leading and trailing ordinary spaces and reduce repeated ordinary spaces between words. For imported nonbreaking spaces, SUBSTITUTE with CHAR(160) can replace them before trimming.

Can I apply PROPER to a whole column?
Enter the formula beside the first source value, then fill it down for the rows you need. Review the results, especially names and acronyms. If you need fixed text afterward, copy the results and paste values into the destination.

Choosing when to use PROPER

PROPER is a quick, useful way to make inconsistent text more readable when a uniform, word-by-word capitalization rule is acceptable. It works well for many labels and ordinary names, particularly when you retain the original data and review exceptions. For acronyms, brand spellings, and personal names with specific conventions, automatic capitalization is only a starting point: check the final text against a reliable source or the person’s stated preference.

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.