How to Change Case in Excel: Uppercase, Lowercase, and Proper Case

To change case in Excel, use =UPPER(A2) for uppercase, =LOWER(A2) for lowercase, or =PROPER(A2) for proper case. Enter the formula in a helper column, copy it down, then copy the results and paste them as values if you want to replace the original text.

Excel does not have the same one-click Change Case button that Microsoft Word has. In worksheets, the most reliable method is to use formulas, especially when you need repeatable cleanup for imported names, emails, product codes, or lookup values.

You can download the change case example workbook to practice the formulas from this guide.

Microsoft Support's page on changing the case of text in Excel lists the same three core functions. The examples below show how to use them in real worksheet cleanup.

How to Change Text Case in Excel: The Short Answer

Use these formulas when the original text is in cell A2:

The helper-column workflow is usually the safest approach:

1. Insert a blank column next to your text.
2. Enter the case formula in the first data row.
3. Copy the formula down.
4. Copy the formula results.
5. Use Paste Special > Values to replace the formulas with fixed text.

That last step matters. If you delete the original text while formulas still refer to it, the formula results may change or break.

Change Text to Uppercase with UPPER

Use the UPPER function when every letter should become uppercase.

For example, if A2 contains west region, enter this in B2:

=UPPER(A2)

Excel returns:

WEST REGION

Uppercase is useful for:

• product codes,
• region labels,
• state abbreviations,
• short identifiers,
• imported text that needs a consistent format.

Example:

Use uppercase carefully for names and titles. UPPER is great for codes, but it usually looks harsh in customer-facing reports.

Change Text to Lowercase with LOWER

Use the LOWER function when every letter should become lowercase.

If A2 contains SALES@EXAMPLE.COM, enter this in B2:

=LOWER(A2)

Excel returns:

sales@example.com

Lowercase is especially useful for email addresses, usernames, imported IDs, and text matching. It can also help when you are preparing data for lookups or comparisons.

Example:

If you are comparing lists after cleaning text, pair this with a comparison formula. The guide on comparing two columns in Excel shows several ways to check whether cleaned values match.

Change Names to Proper Case with PROPER

Use the PROPER function when you want the first letter of each word capitalized.

If A2 contains john smith, enter this in B2:

=PROPER(A2)

Excel returns:

John Smith

Proper case is useful for names, locations, department names, and labels that should be readable in a report.

Example:

There is one important limitation: PROPER follows a simple capitalization rule, not human naming judgment. It may turn MCDONALD into Mcdonald, USA into Usa, and Q4 SALES into Q4 Sales. Always scan the results when your data contains acronyms, brand names, or surnames with unusual capitalization.

Clean Extra Spaces Before Changing Case

Imported data often has more than a letter-case problem. It may also contain leading, trailing, or repeated spaces.

Use TRIM before PROPER when names or labels have extra spaces:

=PROPER(TRIM(A2))

If A2 contains john smith , the formula returns:

John Smith

This pattern is useful because TRIM removes extra spaces first, then PROPER applies the capitalization.

Example:

If a lookup fails because text values look the same but do not match, inconsistent spaces and letter case are common causes. The guide on VLOOKUP not working with text values covers that cleanup problem in more detail.

Replace the Original Text with the Changed Case

Formulas create a new result. They do not change the original cell in place.

To replace the original text after you create the changed-case values:

1. Select the formula results.
2. Copy them with Ctrl+C on Windows or Command+C on Mac.
3. Select the original cells.
4. Use Paste Special > Values.

After you paste values, Excel keeps the displayed text and removes the formulas.

Do this only after you have checked the results. For important worksheets, keep a backup copy of the original column until you know the cleanup worked.

If you want the result in the same cells, this helper-column plus Paste Special workflow is the practical method. Excel formulas cannot rewrite the cells they refer to.

Use Flash Fill for One-Time Case Changes

Flash Fill can be faster than formulas when you are doing a small, one-time cleanup.

Suppose column A contains names in all caps:

JOHN SMITH
MARIA GARCIA
PRIYA PATEL

In B2, type the result you want:

John Smith

Then use Flash Fill. On Windows, press Ctrl+E. On Mac, use the Flash Fill command from the Data tab if the keyboard shortcut is not available.

Flash Fill is convenient because it looks at your example and fills the rest of the pattern. The tradeoff is that it is not as transparent as a formula. If someone reviews the workbook later, a formula like =PROPER(A2) is easier to audit.

Flash Fill is also not dynamic. If the source text changes later, the Flash Fill results do not automatically recalculate.

Use Flash Fill when:

• you need a quick one-time fix,
• the pattern is obvious,
• you do not need the workbook to update automatically later.

Use formulas when:

• the source data may change,
• you need to document the logic,
• you want a repeatable cleanup step.

Use Power Query for Repeatable Imports

If you clean the same imported file every week or month, Power Query may be a better long-term option than worksheet formulas.

Power Query can transform text columns to uppercase, lowercase, or capitalized words as part of a repeatable data-cleaning process. That makes sense when your source data is refreshed often and you do not want to rebuild helper columns each time.

The general workflow is:

1. Select the source data.
2. Use Data, From Table/Range.
3. Select the text column in Power Query.
4. Use Transform, Format, then choose lowercase, UPPERCASE, or Capitalize Each Word.
5. Load the cleaned data back to Excel.

Use Power Query when:

• the data comes from a recurring export,
• the cleanup has several steps,
• you need the same transformation every time,
• the worksheet should stay clean after refresh.

Use worksheet formulas when you want a simple, visible method that any beginner or intermediate Excel user can inspect.

Which Method Should You Use?

For most everyday worksheets, start with formulas. They are clear, easy to copy, and easy to troubleshoot.

Common Mistakes

Expecting the Formula to Change the Original Cell

=UPPER(A2) returns a new value in the cell where you enter the formula. It does not rewrite A2.

Use a helper column first, then paste values over the original text if you want to replace it.

Using PROPER on Acronyms

PROPER capitalizes words by rule. It does not know that USA, HR, or API should stay uppercase.

After using PROPER, scan the result for acronyms and brand names.

Forgetting Hidden Spaces

Letter case may not be the only issue. If your cleaned values still do not match, check for extra spaces or hidden characters.

Start with:

=TRIM(A2)

Then combine it with the case function you need:

=LOWER(TRIM(A2))

or:

=PROPER(TRIM(A2))

Deleting the Source Column Too Soon

If your formula in B2 refers to A2, deleting column A can break or change the result. Copy the formula results and paste them as values before removing the source column.

Frequently Asked Questions

Does Excel have a Change Case button?

Excel does not have the same Change Case button that Word has for selected text. In Excel, use UPPER, LOWER, or PROPER, or use Flash Fill for a quick one-time conversion.

How do I change all caps to proper case in Excel?

Use PROPER. If the all-caps text is in A2, enter:

=PROPER(A2)

Then copy the formula down. If the text also contains extra spaces, use:

=PROPER(TRIM(A2))

How do I change lowercase to uppercase in Excel?

Use UPPER. If the lowercase text is in A2, enter:

=UPPER(A2)

Can I change case without formulas?

Yes. Flash Fill can change case based on an example you type, and Power Query can transform text columns during an import. Formulas are still the clearest option when you want the logic visible in the worksheet.

What is the shortcut to change case in Excel?

Excel does not have a general worksheet shortcut like Word's Change Case shortcut. For formula-free pattern filling, Ctrl+E runs Flash Fill on Windows. For a repeatable formula method, use UPPER, LOWER, or PROPER in a helper column.

Bottom Line

Use UPPER, LOWER, and PROPER when you need a clear, repeatable way to change case in Excel. Add TRIM when the imported text has extra spaces, and paste the formula results as values when you want to replace the original text.