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. Most people learn this as a sequence of clicks and forget it by next week; learning it as a pattern instead is what lets you apply it to the next, slightly different version of the problem without starting from scratch. That is the difference this page is trying to make. The difference between a quick fix and a sheet you can trust is the extra minute you spend validating “letter case change in excel”. Start on a copy or a tiny sample, keep the affected cells 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 workflow that saves repeating the same clicks every week, 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. Nothing on this page is behind a login or a download: the exact answer is at the top, and the detail below it is there for when you need it. That is the whole promise here — the answer first, and just enough context to make it stick. For “letter case change in excel”, 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
On the way here you may have searched this as “how to change letter case in excel”, “change letter case in excel” and “how to change the letter case in excel” — it is all the same task, and this page is the single, complete answer to it.
Why do people search for this in so many different ways?
Because the same task has many names. “how to change letter case in excel”, “change letter case in excel”, “how to change the letter case in excel” all point at the one operation explained on this page, which is why they all lead here.