How to change case manually in Excel
Excel has no Change Case button like Word does. Instead it offers three worksheet functions, each used through a helper column.
UPPER, LOWER and PROPER
- Insert an empty column next to the text you want to change.
- Enter
=PROPER(A2),=UPPER(A2)or=LOWER(A2)in the first cell and fill it down. - Copy the helper column and use Home › Paste › Paste Values over the original column.
- Delete the helper column.
Repeat for every column you want to change. The functions work on any text, so they also change email addresses and product codes if those are in the range.
Sentence case
There is no sentence-case function. A common formula capitalises only the first letter of the cell:
=UPPER(LEFT(A2,1))&LOWER(MID(A2,2,LEN(A2)))
It does not capitalise the start of a second sentence in the same cell, and it lowercases the word “I” in the middle of a sentence.
Flash Fill
Type the result you want next to the first value, for example “Priya Shah” beside “PRIYA SHAH”, then press Ctrl+E (or Data › Flash Fill). Excel copies the pattern down the column. Flash Fill is clever but unpredictable with irregular data, and it does not update if the source changes.
Using Word
Copy the column into Word, select it, press Shift+F3 to cycle between UPPER CASE, lower case and Capitalise Each Word, then paste it back into Excel. This works for small lists but is easy to misalign when pasting back.
Known quirks of PROPER
PROPER capitalises every letter that follows anything other than a letter. That gives the right answer for “o’brien” (O’Brien) and “mary-jane” (Mary-Jane), but the wrong one for “don’t” (Don’T), “3rd floor” (3Rd Floor) and “iPhone” (Iphone).
Where this tool helps
Customer and contact lists. Names typed by customers arrive as “priya shah”, “RAHUL MEHTA” and “aNITA dESAI” (caps lock left on). Proper Case makes mail merges and printed labels look professional.
Addresses and cities. One system exports “AHMEDABAD”, another “ahmedabad”. Making them consistent means filters and pivot tables show one city instead of two.
Product descriptions. Supplier catalogues written entirely in capitals are hard to read on a website. Sentence case turns “STAINLESS STEEL WATER BOTTLE. 1 LITRE.” into “Stainless steel water bottle. 1 litre.”
Codes and identifiers. UPPER CASE makes reference numbers, postcodes and country codes uniform before matching them against another list.
How the tool handles tricky text
- Emails, web links and codes are skipped by default: anything that looks like an address, a URL, a single token containing a digit (INV-0042, SKU12, A12B) or a short abbreviation in capitals (USA, GST, HR).
- Proper Case is smarter about apostrophes and numbers. “o’brien” becomes “O’Brien” because the prefix is a single letter, while “don’t” stays “Don’t” and “3rd” stays “3rd”.
- Sentence case capitalises every sentence in a cell, the start of each new line and the word “I”.
- Numbers, dates and headers are never changed.
- Languages without capitals are safe. Hindi, Gujarati and similar scripts come through unchanged; accented Latin letters are converted properly.
There are limits. No automatic tool can know that “McDonald” or “iPhone” need an unusual capital, and Sentence case lowercases abbreviations inside a sentence, so “PAID VIA UPI” becomes “Paid via upi”. Skim the highlighted cells in the preview for brand names and surnames like these.
Examples of each style
| Original | Proper Case | UPPER CASE | Sentence case |
|---|---|---|---|
| priya SHAH | Priya Shah | PRIYA SHAH | Priya shah |
| o’brien patrick | O’Brien Patrick | O’BRIEN PATRICK | O’brien patrick |
| mary-jane watson | Mary-Jane Watson | MARY-JANE WATSON | Mary-jane watson |
| 3RD FLOOR, TOWER B | 3rd Floor, Tower B | 3RD FLOOR, TOWER B | 3rd floor, tower b |
| delivered. thank you | Delivered. Thank You | DELIVERED. THANK YOU | Delivered. Thank you |
As a rule of thumb, use Proper Case for people, places and company names, UPPER CASE for identifiers and short labels that other systems will match against, lower case for email addresses and usernames if you choose to include them, and Sentence case for anything that reads like prose: descriptions, notes, comments and product titles. Mixing styles in one column is what makes a list look careless, so pick one per column and apply it to every row.
A good order for cleaning names
Remove extra spaces first, so “Priya Shah” with a double space becomes “Priya Shah”. Then change the case. Finally remove duplicates: once spacing and capitals agree, records for the same person are much easier to match.