How to Convert Case in Excel

Someone sends you a spreadsheet with 800 names typed in caps lock. Your deadline is close, and retyping every cell would eat your whole afternoon. Here is the good news: you can convert case in Excel in under a minute. This guide shows you five ways, from simple formulas to AI, including one method almost no Excel guide mentions.

Quick Answer: The Three Formulas You Need

Keep reading for the exact steps, because each formula has one trap that can ruin your data if you skip it.

Method 1: UPPER, LOWER, and PROPER Formulas

Excel gives you three built-in functions to change text case. They work the same way, so once you learn one, you know all three. Microsoft documents them in its official Change the case of text guide.

Excel Convert Lower Case to Upper Case with UPPER

1. Click an empty cell next to your text, for example B2.
2. Type =UPPER(A2) and press Enter.
3. Drag the fill handle down to copy the formula for every row.

Every letter in the cell turns into a capital. Numbers, spaces, and symbols stay exactly as they are.

Excel Convert Upper Case to Lower Case with LOWER

Use =LOWER(A2) the same way. This is the fastest fix for text that arrives in full caps from an old database or a form export.

Convert to Title Case in Excel with PROPER

Type =PROPER(A2) to capitalize the first letter of every word. It is perfect for name lists and address columns.

The trap: your new column holds formulas, not text. If you delete column A now, your results break. Fix it in three steps: select the formula cells, press Ctrl+C, then right-click and choose Paste, then Values. Now the text is real, and you can delete the helper column safely.

Method 2: Flash Fill, the No-Formula Way

If formulas make you nervous, Flash Fill does the work by watching your pattern.

1. In the cell next to your first entry, type the text the way you want it, for example "John Smith" next to "JOHN SMITH".
2. Press Enter, then press Ctrl+E.
3. Excel fills the whole column, matching your pattern instantly.

Flash Fill feels like magic the first time you use it. It also handles mixed jobs, like proper-case names with uppercase state codes in the same cell, which formulas cannot do alone.

Method 3: The Sentence Case Formula Excel Forgot

Here is something strange: Excel has no built-in sentence case function. There is no =SENTENCE() and most guides never tell you.

Use this formula instead:

=UPPER(LEFT(A2,1))&LOWER(RIGHT(A2,LEN(A2)-1))

It capitalizes the first letter of the cell and makes everything else lowercase. It works well for single sentences, like product descriptions or survey answers. For text with several sentences per cell, Method 5 below handles it better in one click.

Method 4: Power Query for Big, Repeating Jobs

When you clean the same report every week, stop fixing it by hand. Power Query can convert text to upper case, lower case, or title case as a saved step.

1. Select your data and go to Data, then From Table/Range.
2. Right-click the column, choose Transform, then pick UPPERCASE, lowercase, or Capitalize Each Word.
3. Click Close & Load.

Next week, paste the new data and press Refresh. The case fixes itself. This method rewards you every single week after the five minutes it takes to set up.

Method 5: Skip Formulas Completely, Use a Free Case Converter

Sometimes you do not want formulas, helper columns, or paste-values gymnastics. You want the text fixed now.

Copy your cells then paste them into our free Case Converter tool. Click on the style you need. Then paste the result back into Excel.

The tool can handle styles.These include:

• Sentence case
• Title Case
• UPPERCASE
• lowercase
• Even some styles Excel cannot do, like aLtErNaTiNg case.

Everything happens in your browser.So your data never gets. Stored anywhere.This method also solves the -sentence problem from another method.The tool finds every sentence. Capitalizes each one correctly.While you are using the tool you can also check your text with our Character Counter or Word Counter.

This helps you know the length of your text before putting it into a report or a web page.

How to Convert Case in Excel with AI Tools

People are searching for AI help with spreadsheets more.Gartner says that worldwide AI spending will reach $2.52 trillion in 2026.This is up 44% from the year.Microsoft reports that over 450 million people use its Copilot assistant for work.This change also affects how people fix text.Using Copilot in Excel.If you have Copilot in Excel you can skip using formulas.

just type a request like this:

"Convert column A, to proper case and put the result in column B."

Copilot will write and apply the formula for you.Using ChatGPT.

ChatGPT works in a way.you describe your data. Ask for the formula.Then you paste the formula into Excel yourself.you can use Copilot or ChatGPT to convert case in Excel.Both tools make it easy to change the case of your text.

One honest warning. AI assistants sometimes pick the wrong range or misread your pattern, and they need a subscription or an internet connection. For a five-second job like case conversion, a free browser tool or a simple =UPPER() is still faster than writing a prompt. Use AI when the job is complex, and use the direct methods above when it is not.

Common Problems When You Convert Case in Excel

The formula just sits there as text. Your column is formatted as Text. Change it to General (Home tab, Number format menu), then press F2 and Enter on the cell.

PROPER ruins acronyms and apostrophes. PROPER turns NASA into Nasa and don't into Don'T, because it capitalizes any letter that follows a non-letter character. Fix the few broken entries with Find & Replace, or run the text through a smarter Case Converter that handles apostrophes correctly.

You see a #NAME? error. You misspelled the function, for example =UPER instead of =UPPER. Retype the formula and the error disappears.

Your sentences run together after conversion. Split long cells first. Our Sentence Counter shows you how many sentences each block of text really contains before you convert it.

FAQs

What is the shortcut to change case in Excel?

Excel has no direct keyboard shortcut like Word's Shift+F3. The closest thing is Flash Fill with Ctrl+E, which copies the case pattern you type in the first cell.

How do I convert case in Excel without formulas?

Use Flash Fill (Ctrl+E), Power Query, or copy your cells into a free online case converter and paste the result back.

Does converting case change my numbers or dates?

No. UPPER, LOWER, and PROPER only touch letters. Numbers, dates, and symbols pass through unchanged.

How do I convert an entire column at once?

Enter the formula in the first row, then double-click the small square at the bottom-right corner of the cell. Excel copies the formula down the whole column instantly.

Which method is fastest for a one-time fix?

For a handful of cells, Flash Fill wins. For hundreds of mixed cells with multiple sentences, pasting into a browser case converter is usually the fastest route.

Final Thoughts

Nobody should spend an afternoon retyping text that Excel can fix in seconds. Start with UPPER, LOWER, and PROPER for quick jobs, move to Flash Fill when you want zero formulas, and set up Power Query for reports you clean every week. When you need sentence case, special styles, or a no-formula fix, you now know how to convert case in Excel the smart way, and our free Case Converter is one paste away. Writers polishing the finished text can also check phrase usage with our Keyword Density Checker before publishing.