Knowledge base / Excel

Excel PROPER: capitalization rules and name exceptions

I explain the capitalization rule after separators and show why acronyms and proper names need review.

Kajo RudzińskiPublished Updated 4 min read

Short block sequences with a tall first element and smaller following elements

You receive a list of names written in inconsistent case and want a uniform presentation. In English Excel, the relevant function is PROPER; its Polish name is Z.WIELKIEJ.LITERY. The shortened form Z.WIELKIEJ is not a valid function name.

I treat the result as a suggestion to review. The function applies a character rule. It does not know the correct spelling of every surname, acronym or brand. A few small examples show both its use and the boundary of automatic cleanup.

Name, syntax and availability

=PROPER(A2)

The Polish equivalent is =Z.WIELKIEJ.LITERY(A2). There is one argument, so this simple example involves no argument separator to translate. Text entered directly into a formula needs double quotation marks. A cell reference does not.

Microsoft documents PROPER for Microsoft 365 and Excel 2024, 2021, 2019 and 2016. It capitalizes the first letter and letters following non-letter characters, while lowercasing the remaining letters. You do not need an extra LOWER function inside the expression to handle mixed input case.

A helper-column example

The names below are synthetic. Put a heading in A1 and the three values in A2:A4. Enter the formula in B2 and fill it down.

Row Text in A Result in B
2 jan kowalski Jan Kowalski
3 ANNA NOWAK Anna Nowak
4 aDa kOT Ada Kot

You can derive the answers directly from the rule: the first letter and the letter after the space become uppercase, and the remaining letters become lowercase. Column A remains available, allowing you to compare the output with its source before accepting it as the current spelling.

The formula returns new text. It does not edit A2, verify a person’s identity or detect a misspelled surname. If a name contains transposed letters, changing capitalization does not restore their correct order. Presentation cleanup and spelling correction are separate tasks.

Apostrophes, digits and hyphens

A word boundary in this function follows a technical rule. A space is only one possible separator. Apostrophes, hyphens and digits can also cause a following letter to become uppercase.

Synthetic text PROPER result
o’reilly O’Reilly
mcdonald’s Mcdonald’S
2nd 2Nd
anna-maria Anna-Maria

The first result may match the intended spelling, while the second reveals the limitation: the function lowercases internal letters and capitalizes the letter after the apostrophe. It has no language rule that recognizes the name. These effects follow from the documented definition, rather than from a dictionary of exceptions.

I would avoid applying a long chain of SUBSTITUTE expressions to repair fragments throughout a surname database. A substring replacement can also affect a different valid spelling. For known exceptions, maintain an approved form and an unambiguous key through which to retrieve it.

Two trays show an original block arrangement and a mechanically standardized version

Acronyms and proper names

USA becomes Usa, while KajoData becomes Kajodata. PROPER does not recognize the intention behind a name. I would not apply it indiscriminately to brands, product codes or identifiers that require their exact original case.

An English title containing small conjunctions may also require editorial rules that PROPER does not apply. If you only want to capitalize the beginning of a sentence, capitalization after every separator answers a different question. Name the desired transformation before choosing a formula.

The original is useful when a recipient reports an exception. Preserving it lets you return to the data and establish the appropriate form. After replacing the source with a standardized version, you may be unable to reconstruct which internal capitals were intentional.

Spaces need a separate operation

Changing case does not remove extra spaces. For ordinary spaces, you can combine the functions:

=PROPER(TRIM(A2))

In Polish Excel, use =Z.WIELKIEJ.LITERY(USUŃ.ZBĘDNE.ODSTĘPY(A2)). TRIM removes leading and trailing ordinary spaces and leaves single spaces between words. It does not remove nonbreaking spaces with character code 160 on its own. Two combined functions may therefore be insufficient after a web import.

I separate these operations during diagnosis too. First inspect the problematic character, then decide how to handle it. A neater appearance does not prove that every invisible character disappeared or that two records describe the same person.

Saving the result and a short exercise

Once you have reviewed the output, copy the helper column and paste values into the intended destination. Microsoft’s case-conversion instructions show this workflow. Pasting formulas normally retains their dependency on the source cells.

For practice, prepare four values: a simple name, an acronym, text containing an apostrophe and text with a double space. Predict each result before entering the formula. Then decide which outputs you would accept in a report and which need review. That distinction matters more than merely filling the formula down.

For changing the whole string, use UPPER or LOWER. Each implements a different, explicit rule.

Key takeaways

What is the Polish name of PROPER?

The Polish function name is Z.WIELKIEJ.LITERY. The shortened form Z.WIELKIEJ is incorrect.

Does PROPER preserve the acronym USA?

No. It produces Usa, so acronyms and approved proper names need a separate policy.

Should I apply LOWER before PROPER?

No. PROPER already lowercases the remaining letters. Spaces and approved exceptions may require separate handling.

AI was used in an automated way while working on this article. If you want to learn how to do it too, check out this project.

Kajo Rudziński

Newsletter KajoData

Let’s keep in touch.

I write about data analysis, learning and changing careers. My newsletter and the sign-up form are in Polish. If that works for you, I’d be glad to see you there.