Quick answer: Excel does not use a single Change Case button like Microsoft Word. The most reliable worksheet formulas are UPPER(), LOWER() and PROPER().
| Goal | Formula for A2 |
|---|---|
| UPPERCASE | =UPPER(A2) |
| lowercase | =LOWER(A2) |
| Proper Case | =PROPER(A2) |
Method 1: Convert Text to Uppercase
If A2 contains free tool calculator, enter:
=UPPER(A2)The result is FREE TOOL CALCULATOR.
Method 2: Convert Text to Lowercase
=LOWER(A2)If A2 contains HELLO WORLD, the result is hello world.
Method 3: Convert Text to Proper Case
=PROPER(A2)PROPER capitalizes the first letter of words and lowercases other letters according to Excel’s function behavior. Review names, acronyms and brand styling manually because automatic title-style capitalization may not match the required spelling.
How to Replace the Original Text
- Enter the case-conversion formula in a new column.
- Fill the formula down.
- Copy the converted results.
- Use Paste Special → Values over the original cells if you no longer need the formulas.
- Delete the helper column after verifying the data.
Keep a backup before replacing a large dataset.
Method 4: Use Flash Fill
Flash Fill can recognize a pattern from examples. Type the desired version beside the first source value, begin the next example, and use Flash Fill when Excel detects the pattern. This is convenient for one-time cleanup, but formula-based methods are easier to audit when source data will continue changing.
Method 5: Change Case With Power Query
Power Query is useful for repeatable imports and transformations. Load the data into Power Query, select the text column, and use the text-format transformations for uppercase, lowercase or capitalization as appropriate. The transformation can then be reapplied when the query refreshes.
Combine Case Conversion With TRIM
If imported text also contains unwanted spaces, you can combine functions:
=PROPER(TRIM(A2))This first applies TRIM’s space cleanup and then converts the result to proper case.
Which Method Should You Use?
| Situation | Suggested method |
|---|---|
| Simple worksheet conversion | UPPER, LOWER or PROPER |
| One-time pattern cleanup | Flash Fill |
| Repeatable imported-data process | Power Query |
| Replace source values | Formula + Paste Special Values |
Common Problems
- Formula displays instead of result: check whether the cell is formatted as Text or Show Formulas is enabled.
- PROPER changes an acronym: correct special names/acronyms after conversion or use a more customized formula/process.
- Results change when source text changes: this is expected for formulas; paste values if you need static output.
- Flash Fill guesses incorrectly: provide more examples or use a deterministic formula.
Frequently Asked Questions
Can I change case without a formula?
Yes. Flash Fill or Power Query can handle many case-conversion tasks without worksheet formulas.
Can I change case in the same cell directly?
Standard worksheet formulas return their result in another cell. A common workflow is to calculate in a helper column and paste the results back as values.
Why does PROPER capitalize letters I do not want capitalized?
PROPER follows its own capitalization rules and does not understand every name, acronym or brand convention. Review special cases manually.
Last reviewed: October 2026. Menu names can vary slightly by Excel version and platform.
