Excel's built-in PROPER function converts text to proper case by capitalizing the first letter of every word separated by a space, so "the lord of the rings" becomes "The Lord Of The Rings" in a single formula. The function treats every space as a word boundary, which means it capitalizes articles (a, an, the), short prepositions (of, in, on, at, to, for), and coordinating conjunctions (and, but, or) the same way it capitalizes nouns and verbs. That mechanical behavior is fine for cleaning up messy customer names, product SKUs, or imported data where you just want each word to start with a capital letter. It is the wrong choice for headlines, article titles, book and film titles, slide-deck headings, and reference-list entries that follow a publication's house style, because editorial style guides such as AP, APA 7th edition, Chicago Manual of Style 18th edition, and MLA 9th edition deliberately lowercase those small words except when they are the first or last word of the title. For those jobs you need a title case converter that applies real editorial rules rather than a blanket "capitalize every word" pass.
What Excel's PROPER Function Does to Text
PROPER is one of three case functions Excel ships with, alongside UPPER and LOWER. Its job is narrow: take a text string and return the same string with the first letter of every word capitalized and every other letter lowercase. The function counts a "word" as any sequence of characters separated by a space, so a phrase like "hello-world" entered into PROPER comes back as "Hello-World" because the hyphen is treated as a non-space character that simply joins two halves of one word.
In practice the function has three behaviors worth knowing:
- It ignores numbers and punctuation. A cell containing "item-42 review" returns "Item-42 Review", not "Item-42 review".
- It lowercases everything except the first letter of each space-separated token, which is why "NASA's new rover" becomes "Nasa's New Rover" — a well-known annoyance when working with acronyms and product names.
- It does not look at part of speech, length, or position. The "of" in "Lord of the Rings" gets capitalized, the "of" in "Out of Africa" gets capitalized, and the "of" in a stand-alone headline gets capitalized. There is no built-in concept of a small word.
How to Convert Proper Case in Excel with PROPER
If your goal is to clean up a column of messy text where every word should start with a capital letter, PROPER does the job in five steps:
- Click into an empty cell next to the cell that holds your original text. If your data starts in A1, click into B1.
- Type =PROPER(A1) and press Enter. Excel returns the proper-cased version of A1 in B1.
- Drag the fill handle (the small square at the bottom-right corner of B1) down the column to apply the formula to every row of source data.
- Select the entire output column, press Ctrl+C to copy, then press Ctrl+Shift+V and choose Values to paste the converted text back in place as plain text. This step replaces the formula with the literal string so the output does not break if you delete or sort the source column.
- Delete the helper column once you confirm the result looks right.
The same approach works for whole phrases in a single cell, and it can be combined with other functions: =PROPER(LEFT(A1,FIND(" ",A1&" ")-1)) extracts just the first word of A1, while =PROPER(A1)&" "&PROPER;(B1) joins two already-cased strings. PROPER also handles formulas that return text, such as =PROPER(SUBSTITUTE(A1,"-"," ")) which replaces hyphens with spaces before casing.
Why PROPER Capitalizes the Wrong Words for Headlines
The moment you move from cleaning up data to writing a headline, PROPER's "capitalize everything" rule works against you. The four major English-language editorial style guides all agree on two anchors: the first word and the last word of a title are always capitalized, whatever they are. They disagree on the words in between, and they agree that short function words (articles, short prepositions, coordinating conjunctions) should usually stay lowercase. That is the opposite of what PROPER produces.
For a phrase like "The Art of War in the Modern Age", AP, APA, Chicago and MLA all output The Art of War in the Modern Age. That is because every word there is either a content word of five or more letters, or the first or last word of the title. Change the phrase slightly to "The Out-of-Africa Effect on Modern Film" and the four guides start to disagree:
| Word type | AP | APA 7th edition | Chicago 18th edition (2024) | MLA 9th edition |
|---|---|---|---|---|
| Articles (a, an, the) | lowercase | lowercase | lowercase | lowercase |
| Coordinating conjunctions (and, but, or, nor, for, so, yet) | lowercase | lowercase | lowercase | lowercase |
| Prepositions of 3 letters or fewer (of, in, on, to, at, by, for) | lowercase | lowercase | lowercase | lowercase |
| Prepositions of 5 letters or more (after, before, between, through) | capitalize | capitalize | capitalize | lowercase |
| First word of title | capitalize | capitalize | capitalize | capitalize |
| Last word of title | capitalize | capitalize | capitalize | capitalize |
The MLA column is the one that differs on long prepositions such as "against" or "between", which Chicago now capitalizes because of a change in the 18th edition published in 2024. AP and APA share a four-letter threshold for prepositions, while Chicago uses a five-letter threshold and MLA lowercases prepositions of any length. A four-letter preposition such as "with" is therefore capitalized by AP and APA but lowercase under Chicago and MLA, which is exactly the kind of detail a generic capitalize-every-word function cannot get right. That is the kind of detail a generic capitalize-every-word function cannot get right.
How to Use a Title Case Converter for Editorial Styles
When the headline has to follow a real style guide, paste it into a tool that has the rules built in rather than guessing by hand. The Title Case Converter (AP, APA, Chicago) applies published editorial rules instead of a mechanical capitalize-every-word pass, and it shows all four outputs side by side so you can see exactly where the guides disagree.
- Type or paste the headline you want to set in title case.
- Choose the style guide your publication follows: AP, APA, Chicago or MLA.
- Copy the converted headline, or compare the four style outputs listed underneath before deciding.
Three mechanics of the tool matter for anyone coming from Excel:
- The converter is a deterministic word-list matcher. It does not parse parts of speech, so a word that appears on its preposition list is treated as a preposition even when it is acting as an adverb or a verb particle in your sentence. That is also why two edge cases have to be fixed by hand: MLA capitalizes the word "before" when it introduces a clause but lowercases the same word as a preposition, and AP has capitalized the "to" of an infinitive since 2019. Neither case is detected automatically.
- Any word you type with an internal capital — such as iPhone, eBay, HTML5, or NASA — is passed through untouched. That is how acronyms and brand names survive conversion instead of being flattened into Iphone and Nasa.
- A headline pasted entirely in capitals is treated differently from mixed-case text with one acronym in it. An ALL-CAPS line has no lowercase letters to mark acronyms apart from shouted words, so the whole line is lowercased first and then re-cased using the style rules. Within a mixed-case title, words in full capitals of two letters or more (NASA, FBI, EU) are still preserved.
When to Use Excel's PROPER vs a Title Case Converter
Both approaches have a job they were built for, and the choice comes down to whether your text follows a house style guide or not.
Use Excel's PROPER when:
- You are cleaning imported data, customer names, addresses, or product labels where every word should simply start with a capital letter.
- You need the operation to live inside the spreadsheet, recompute when source cells change, and respond to formulas such as SUBSTITUTE, TRIM, or CONCATENATE.
- You are preparing data for a system that does not care about editorial rules, such as a CRM import or a mailing-merge source file.
Use a title case converter when:
- You are writing a headline, article title, book or film title, slide title, or reference-list entry that will be copy-edited against a named style guide.
- You need to compare how AP, APA, Chicago and MLA would each set the same headline so you can pick the one your publication uses.
- You have words that must be forced into a specific case — a brand name with internal capitals, an acronym, or a word that has to break the small-word rule.
For spreadsheet housekeeping where the output stays inside Excel, a safe whitespace cleanup pass often goes alongside PROPER, because stray tabs and double spaces inside the source cell produce output like "The Lord Of The Rings" with visible gaps that have to be fixed afterwards.
Limits of Any Rule-Based Title Case Tool
Both PROPER and a style-guide converter share one structural limit: they only change letter case. Punctuation, spacing, word order, and the presence of hyphens, colons, or em dashes are never altered. That means a typo such as "the art of war: a modern reading" keeps the colon in exactly that position; the converter simply capitalizes the first word after the colon under APA 7's rule and lowercases it under MLA's rule.
A second limit is the part-of-speech problem. The Title Case Converter (AP, APA, Chicago) uses published word lists for articles, conjunctions, and prepositions rather than tagging grammar, so it cannot tell when "before" is a preposition versus a subordinating conjunction. The MLA rule on "before" is one explicit case where the tool is honest about not handling the distinction; AP's 2019 change on the infinitive "to" is the other. In both cases the workaround is the same: edit those words by hand after the conversion.
A third limit is brand names and acronyms. Both Excel's PROPER and the style-guide converter lowercase words they do not recognize. Type a brand name normally and it comes back with only its first letter capitalized. Type it with an internal capital or in full capitals and the converter preserves it. This is the simplest reliable workaround for NASA, iPhone, HTML5, macOS, and the long list of product names that do not survive a clean "first letter only" pass.
Where the Rules Come From
Every rule and word list in the converter is taken from a published source rather than from memory. The APA rules come from the APA Style page on title case capitalization (see APA Style: Title Case). The MLA rules come from the MLA Style Center's article on prepositions in titles. The Chicago behavior on prepositions of five or more letters comes from the Chicago Manual of Style's own announcement of the 18th edition, published in 2024 (see CMOS Shop Talk: announcing the 18th edition). AP's composition-title rule is drawn from secondary sources that quote the AP entry, because the AP Stylebook itself is behind a subscription — a limit stated plainly on the tool's own page rather than glossed over.
Everything runs locally in your browser, so nothing you type is uploaded, stored, or attached to an account. That is the right default for unpublished headlines, draft chapter titles, and reference lists that may not yet be public.
For a deeper look, see Extract URLs From Excel Hyperlinks Without VBA.