In Excel: use =UPPER(text), =LOWER(text) or =PROPER(text) — PROPER capitalises the first letter of every word, which is right for names and wrong for almost everything else.
On this page8
Syntax
Arguments
| Argument | required / optional | Description |
|---|---|---|
text | required | The text to recase. Numbers and punctuation pass through unchanged. |
Related functions
Add a helper column beside the text you want to recase.
Type =PROPER(, =UPPER( or =LOWER( and click the first cell — wrap in TRIM if padding is likely.
Fill down and scan the result for acronyms and names PROPER has mangled.
Copy the helper column and Paste Special → Values over the original, then delete the helper.
What this does
These three recase text. UPPER and LOWER are unsurprising; PROPER is the one that needs care, because it capitalises the first letter of every word and lowercases the rest. That works on "JOHN SMITH" and mangles "IBM" into "Ibm", "O'Brien" into "O'brien" and "3M" into "3M" only by luck. None of them changes the underlying data — they return a new string, so cleaning a column means adding a helper column and then pasting the result back as values. Numbers and punctuation pass through untouched. The same idea underpins a lot of everyday Excel work, so the few minutes spent getting it right here pay back across every sheet you build afterwards. Treat it as a pattern, not a one-off, and it stops being something you look up and starts being something you reach for. For “proper function in excel”, the reliable version is a short checking loop, not just the first command that appears to work. Run it on a deliberately small range first, watch how the affected formula change, and only then apply the same setup to the full sheet. 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. That is what makes a text operation that turns messy entries into clean, usable data useful in real work: repeatable, auditable, and not dependent on memory or luck.
A worked example
Normalising imported names typed inconsistently: =PROPER(TRIM(A2)) turns " jOHN smith " into "John Smith". Standardising product codes for matching: =UPPER(B2) makes "ab-1024" and "AB-1024" comparable. Note the limit: =PROPER("IBM annual report") returns "Ibm Annual Report", which is why acronym-bearing text needs a manual pass or a SUBSTITUTE afterwards. These three are the fastest fix for inconsistently typed imports, provided you know PROPER cannot be trusted with acronyms. 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 “proper function 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
- Trusting PROPER on data containing acronyms or names like McDonald and O'Brien, which it capitalises wrongly.
- Expecting the original cells to change; these return a new string and leave the source alone.
- Recasing before trimming, so leading spaces make PROPER capitalise the wrong character.
Frequently asked questions
How do I change case in Excel?
Use =UPPER(A2), =LOWER(A2) or =PROPER(A2) in a helper column, then paste the result back as values.
Why does PROPER break acronyms?
It lowercases everything after the first letter of each word, so IBM becomes Ibm. Acronym-bearing text needs a correction pass afterwards.
Is there a sentence-case function?
No. Combine UPPER on the first character with LOWER on the rest: =UPPER(LEFT(A2,1))&LOWER(MID(A2,2,999)).
Other ways people ask this
People reach this page typing “excel function proper”, “how to use proper function in excel” and “how to use the proper function in excel”, among other phrasings; whichever wording you used, the fix above is the one you want.
Why do people search for this in so many different ways?
Because the same task has many names. “excel function proper”, “how to use proper function in excel”, “how to use the proper function in excel” all point at the one operation explained on this page, which is why they all lead here.