How to Change Text to UPPERCASE or lowercase in Excel

The "everything is in the wrong case" problem

You inherit a column of names shouting in ALL CAPS, or emails where a dedupe fails because Alex@Example.com and alex@example.com count as different strings. To change text to uppercase or lowercase in Excel, use a formula for a live conversion, or a macro when you want the cells fixed for good.

Excel also has no button and no keyboard shortcut for this, unlike Word's Shift + F3. Every method below is a workaround for that gap.

TL;DR: Key takeaways

• =UPPER(), =LOWER(), and =PROPER() change case live, but need a helper column and a paste-as-values cleanup.
• A free macro converts the selected cells in place with one prompt: pick UPPERCASE or lowercase. No helper column.
• Sentence case (capitalize only the first letter) has no built-in function. You build it with a formula.
• Excel has no shortcut for changing case, on Windows or Mac.

Method 1: UPPER, LOWER, and PROPER formulas

=UPPER(A2)     converts to UPPERCASE
=LOWER(A2)     converts to lowercase
=PROPER(A2)    converts To Title Case

Drop the one you need into a helper column, fill down, copy, paste back over the original as values, then delete the helper. Right for a live dashboard cell that must update with the source text. For a one-time column cleanup, it's more steps than the job deserves.

Method 2: The free macro, in place, one prompt

Download Change Case to UPPERCASE or lowercase. Free .xlsm, runs offline. First time using one of our macros? See How to run our tools.

1. Select the range of text to change.
2. Alt + F8, pick ChangeCaseToUpperOrLower, click Run.
3. Type 1 for UPPERCASE or 2 for lowercase.
4. Cells convert in place. It reports how many changed.

It only touches text cells, so numbers, dates, and formulas are left alone. No helper column, no paste-as-values, and a 10,000-row column takes the same one click as a 10-row one.

What about sentence case?

Excel genuinely can't do this on its own. No SENTENCE function exists. Build it with a formula:

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

Turns the FINAL report into The final report. It won't capitalize the letter after a period, so multi-sentence text still needs manual fixes, but for single-sentence entries it's a one-pass fill-down.

Example: normalizing an email list before a dedupe

A marketing coordinator merges three sign-up exports into one 4,000-row email list. The exports disagree on case (Sam.Lee@gmail.com vs sam.lee@gmail.com), so a straight dedupe misses the overlap since Excel treats them as different strings. Running the macro with mode 2 to force lowercase first, then Remove Duplicates by Multiple Columns, collapses the list from 4,000 rows to about 3,100 real contacts.

Frequently asked questions

How do I change text to uppercase or lowercase in Excel without a formula?

Use the free macro. Select the cells, press Alt + F8, run the Change Case macro, and type 1 for uppercase or 2 for lowercase. It converts in place, so there's no helper column or paste-as-values step.

Is there a shortcut to change case in Excel, like in Word?

No. Excel has no equivalent of Word's Shift + F3, on either platform. You can assign your own shortcut key to the case macro in the macro options dialog, which is the closest thing to one.

How do I capitalize just the first letter of a cell?

Use =UPPER(LEFT(A2,1))&LOWER(MID(A2,2,LEN(A2))). It capitalizes the first character and lowercases the rest. For text with several sentences, you'll still fix the letters after each period by hand.

Will changing case affect numbers, dates, or formulas?

No. The macro only changes text-string cells; numbers, dates, and formula cells are skipped. To convert formula results first, freeze them with Convert Formulas to Values.

What to do next

For a quick live conversion, use =UPPER or =LOWER. To fix a whole column for good, download the free macro. If you actually need Title Case for names, use Convert Text to Proper Case instead, and trim whitespace first so stray spaces don't throw off the result.