Devices and HardwareGamingSecurity and PrivacyContact UsAbout Us

How to Change Uppercase to Lowercase in Excel (And Vice Versa)

Excel doesn't have a simple "change case" button like Microsoft Word does — and that surprises a lot of people. If you've ever imported data from another system and ended up with a column full of names in ALL CAPS, or mixed-case text that needs to be standardized, you already know the frustration. The good news: Excel gives you several reliable ways to convert text case, and once you know how they work, it takes seconds.

Why Excel Handles Case Differently Than Word

In Word, case conversion is a formatting operation — you select text and flip it. In Excel, text is stored as data, not formatted content. That means changing case requires either a formula that creates a new value, a Power Query transformation, or a macro. None of these are complicated, but they do work differently than what most people expect.

The Three Core Text Case Functions in Excel

Excel has three built-in worksheet functions specifically for this:

FunctionWhat It DoesExample Result
=LOWER(text)Converts all letters to lowercase"HELLO" → "hello"
=UPPER(text)Converts all letters to uppercase"hello" → "HELLO"
=PROPER(text)Capitalizes the first letter of each word"john smith" → "John Smith"

These functions are available in every version of Excel — desktop, web, and mobile.

How to Use LOWER (Step by Step)

  1. Click on an empty cell next to your data — for example, if your original text is in A1, click on B1.
  2. Type =LOWER(A1) and press Enter.
  3. The lowercase version of the text in A1 appears in B1.
  4. To apply the formula to an entire column, click B1 and drag the fill handle (the small square at the bottom-right of the cell) down through the rest of the rows.

The same logic applies to =UPPER() and =PROPER() — just swap the function name.

Converting the Formula Result Back to Plain Text

Here's the catch: the formula cell contains a formula, not just text. If you delete the original column (A1 in the example above), B1 will show an error. To make the converted text independent, you need to paste it as values:

  1. Select the cells containing your LOWER (or UPPER/PROPER) formulas.
  2. Copy them (Ctrl+C or Cmd+C on Mac).
  3. Right-click on the same selection (or a new destination).
  4. Choose Paste Special → Values (or click the clipboard icon with "123").
  5. The cells now contain plain text with no formula dependency.

After this step, you can safely delete the original column if needed. 📋

Using Flash Fill for Quick Case Changes

If you're on Excel 2013 or later, Flash Fill can handle simple case transformations without formulas. Here's how:

  1. In the cell next to your first data entry, manually type the lowercase version of that value.
  2. Press Enter and start typing the lowercase version of the second value.
  3. Excel will often recognize the pattern and suggest the rest of the column automatically.
  4. Press Enter or Ctrl+E to accept the suggestion.

Flash Fill works well for clean, consistent data. It's less reliable when your source data has irregular formatting, extra spaces, or special characters. Think of it as a shortcut for straightforward jobs, not a replacement for the formula-based approach.

Power Query: The Better Option for Large or Recurring Data 🔄

If you're regularly importing data that needs case conversion — say, a monthly export from a CRM or database — Power Query offers a more scalable solution.

Inside Power Query (accessed via Data → Get & Transform Data):

  1. Load your data into the Power Query editor.
  2. Select the column you want to transform.
  3. Go to Transform → Format and choose lowercase, UPPERCASE, or Capitalize Each Word.
  4. Close and load the result back to your worksheet.

Power Query transformations are non-destructive — your original data source stays untouched. And because the steps are recorded, you can refresh the transformation any time new data comes in without redoing the work manually.

This approach suits users comfortable with a slightly more involved setup, but the long-term payoff is significant for repetitive workflows.

What About VBA Macros?

For power users, a short VBA macro can convert case in-place — meaning it changes the actual cell values without needing a helper column or paste-as-values step. This is useful when you want a one-click solution you can trigger from a button or keyboard shortcut.

The trade-off: macros require enabling the Developer tab, and some organizations restrict macro use in shared workbooks for security reasons. The formula-based approach works in every environment without special permissions.

The Variables That Shape Which Method Works Best

Several factors determine which approach fits your situation:

  • Data volume — A few dozen rows? Formulas work fine. Thousands of rows refreshed regularly? Power Query becomes worth learning.
  • Excel version — Flash Fill requires Excel 2013+. Power Query is most capable in Excel 2016 and later (it exists in 2010/2013 as an add-in). All three case functions work universally.
  • Workflow type — One-time cleanup vs. recurring import changes the calculation entirely.
  • Shared environment — Macros may be restricted; formulas and Power Query are always available.
  • Comfort level — Some users are formula-confident but have never opened Power Query. Others have the opposite experience.

The method that's genuinely most efficient depends on how frequently you're doing this, how your Excel environment is set up, and how much automation feels worth building for your particular workflow. 🧩