How to Change Text Case in Excel, Google Sheets and Word

Almost every spreadsheet or document eventually arrives in the wrong case. A supplier sends a product list in ALL CAPS, a form export comes back entirely lowercase, or a colleague types a heading in a style that does not match the rest of the document. Retyping is slow and introduces typos. This guide covers every reliable way to change text case in the four tools most people use daily, and explains which method to reach for in each situation.

Changing case in Microsoft Excel

Excel has no toolbar button for case. It has three worksheet functions instead, and they all work the same way: you write the formula in an empty column, then paste the result back as values.

• =UPPER(A2) converts the contents of A2 to UPPERCASE.
• =LOWER(A2) converts it to lowercase.
• =PROPER(A2) capitalises the first letter of every word.

Type the formula in B2, then double-click the small square at the bottom-right of the cell to fill it down the whole column. To keep the converted text permanently, select the new column, copy it, then use Paste Special and choose Values. You can now delete the original column safely.

### Sentence case in Excel

Excel has no SENTENCE() function, which surprises most people. The usual workaround is a nested formula:

=UPPER(LEFT(A2,1)) & LOWER(MID(A2,2,LEN(A2)))

This capitalises the first character and lowercases everything after it. It works for single sentences, but it does not re-capitalise after a full stop, and it will flatten proper nouns such as names, brands and place names. For anything longer than one sentence per cell, it is faster to paste the column into a dedicated converter and paste the result back.

### The PROPER() trap

PROPER() capitalises *every* word, including ones that should stay lowercase in a real title, and it mangles anything with an internal capital: "McDonald" becomes "Mcdonald", "iPhone 15" becomes "Iphone 15", and "O''Brien" becomes "O''brien". If the column contains names or product codes, check the output before you overwrite the original.

Changing case in Google Sheets

Google Sheets supports the same three functions — UPPER, LOWER and PROPER — with identical syntax, so any Excel formula you already use will work after an import. Sheets adds one useful extra: because array formulas are native, you can convert an entire column in a single cell.

=ARRAYFORMULA(UPPER(A2:A))

That one formula fills the whole column and updates automatically as new rows arrive, which is handy for a sheet fed by a form. As in Excel, copy and paste as values only when you want to freeze the result.

Changing case in Microsoft Word

Word is the one application with a genuine one-click option. Select your text and either:

• Click the Aa button on the Home tab and pick a case from the list, or
• Press Shift + F3 to cycle through lowercase, UPPERCASE and Capitalise Each Word.

Word offers five options: Sentence case, lowercase, UPPERCASE, Capitalize Each Word, and tOGGLE cASE. Sentence case in Word is smarter than the Excel formula because it re-capitalises after each full stop, question mark and exclamation mark.

Two things to watch. First, Word''s "Capitalize Each Word" is not real title case — it capitalises articles and prepositions that a style guide would leave lowercase. Second, if the original text was typed with the All Caps *formatting* option rather than typed in capitals, changing the case does nothing visible until you clear that formatting from the Font dialog.

Changing case in Google Docs

Google Docs hides the feature under Format → Text → Capitalization, with three choices: lowercase, UPPERCASE and Title Case. There is no sentence case option and no keyboard shortcut by default, which is why many people install an add-on. For occasional use the menu is fine; for a long document, converting the text elsewhere and pasting it back is quicker.

When to use an online converter instead

Built-in options run out quickly in three situations:

1. You need a case the app does not offer — proper title case that respects style-guide rules, aLtErNaTiNg cAsE, camelCase, snake_case or kebab-case for developer work.
2. You are cleaning data, not writing prose — a converter handles thousands of lines pasted at once, without formulas, helper columns or paste-special steps.
3. The text is going somewhere else anyway — if the destination is a CMS, a database import or an email, converting on the way saves a round trip through the spreadsheet.

Our Uppercase Converter, Lowercase Converter, Title Case Converter and Sentence Case Converter all run in your browser: paste a column, copy the result, paste it back. Nothing is uploaded, so client lists and internal documents stay on your machine.

A practical workflow for messy data

When a spreadsheet arrives in an unusable state, this order of operations causes the fewest surprises:

1. Trim whitespace first, so stray spaces do not affect word boundaries.
2. Fix the case second.
3. Fix punctuation and separators last.
4. Spot-check twenty random rows before overwriting the original file.

Keeping the original column until the final check has saved more spreadsheets than any formula.

Frequently asked questions

Can I undo a case change in Excel? Yes, with Ctrl + Z, as long as you have not closed the file. Once you have pasted values over the original column and saved, the original casing is gone — which is why the helper-column method is worth the extra step.

Why does PROPER() lowercase the rest of a word? By design: it uppercases the first letter after any non-letter character and lowercases everything else. Acronyms such as NASA or ID become "Nasa" and "Id".

Is there a shortcut for sentence case in Word? Not directly. Shift + F3 cycles three states only; sentence case must be chosen from the Aa menu.

Does changing case affect formulas that reference the cell? Text comparisons in Excel are case-insensitive by default, so most lookups keep working. EXACT() and some database imports are case-sensitive, so convert before you import, not after.