In Excel: change case with a helper column: =UPPER(A2) for ALL CAPS, =LOWER(A2) for lowercase, =PROPER(A2) to capitalize each word — then paste the results back as values. Excel has no Shift+F3 shortcut like Word.
On this page7
Insert a helper column next to your text.
Use =UPPER(A2), =LOWER(A2), or =PROPER(A2) and fill down.
For sentence case: =UPPER(LEFT(A2,1))&LOWER(MID(A2,2,LEN(A2))).
Copy the helper, Paste Special ▸ Values over the original, delete the helper.
What this does
Excel deliberately has no "Change Case" button; case conversion is done with the three text functions UPPER, LOWER, and PROPER in a helper column. PROPER capitalizes every letter that follows a non-letter, which is right for names ("anna meyer" → "Anna Meyer") but quirky for words with apostrophes or codes ("don't" → "Don'T"). Sentence case needs a small combined formula. Keep the inputs visible and clearly labelled and the whole thing stays auditable — anyone who opens the file later, including you, can see at a glance exactly what feeds the result and change one assumption without hunting through the formula. The difference between a quick fix and a sheet you can trust is the extra minute you spend validating “excel formula capitalize”. Start on a copy or a tiny sample, keep the affected formula visible, and compare the result with the outcome you expected before you touch the real workbook. When a formula is involved, keep the inputs labelled beside it, reference cells instead of typing values, and apply number formatting only after the result checks out. The point is a text operation that turns messy entries into clean, usable data, but the practical win is that someone else can open the file and understand what happened without asking you.
A worked example
Column A holds shouting customer names like "ANNA MEYER". In B2, =PROPER(A2) returns "Anna Meyer"; filling down fixes the whole list. Copy column B, then Paste Special ▸ Values over column A and delete the helper — the originals are replaced in place. Imported data arrives SHOUTING or all-lowercase constantly — CRM exports, form submissions, legacy systems. A helper column with one function call normalizes thousands of rows in seconds. Check the referenced cells, argument order and result type in your workbook. Start with the worked example before changing an input, then compare the changed result with the calculation you expected. An error value or a result of a different type is a reason to inspect the inputs and arguments.
In Google Sheets
The standard worksheet functions used by this example are listed in Google Sheets. Check the cell references, argument separators and input types in the target spreadsheet, then compare the worked result. This formula-availability check does not establish identical menus, keyboard shortcuts or workbook features, and it is not a product execution test. Keep this page bookmarked for the next time the same question comes up. Better still, repeat the steps once in your own workbook — doing it yourself is what turns a copied answer into something you remember. For “excel formula capitalize”, keep the input cells and the result visible while you check the formula in Excel. Follow the worked example and change one input at a time. The steps explain the workbook calculation; this page does not run a live calculator for that task.
Common mistakes
- Looking for Word's Shift+F3 — Excel does not have it.
- Deleting the original column before pasting the formulas back as VALUES, which breaks the references.
- Expecting PROPER to handle "McDonald" or "iPhone" — it returns "Mcdonald" and "Iphone".
- Running PROPER over codes like "A-1b" and getting "A-1B" — letters after digits and dashes get capitalized too.
Frequently asked questions
Is there a change-case shortcut in Excel?
No. Unlike Word's Shift+F3, Excel needs the UPPER/LOWER/PROPER functions, Flash Fill, or a paste from the converter above.
How do I convert case without formulas?
Type the first corrected value and press Ctrl+E (Flash Fill) — or paste your column through the converter above and copy the result back.
What does PROPER do with apostrophes?
It capitalizes the letter after them: "o'brien" becomes "O'Brien" (good) but "don't" becomes "Don'T" (usually not wanted).
Other ways people ask this
This is also commonly searched as “capitalize excel formula” and “formula to capitalize in excel”. They describe the identical operation, so you are in the right place no matter how you phrased it.
Why do people search for this in so many different ways?
Because the same task has many names. “capitalize excel formula”, “formula to capitalize in excel” all point at the one operation explained on this page, which is why they all lead here.