How to Convert Case in Excel: 5 Methods + Formulas

Excel can change text to uppercase, lowercase, or proper case without manually retyping every cell. For most worksheets, use UPPER, LOWER, or PROPER. Flash Fill is useful when you want a no-formula option, while Power Query is better for transformations you need to repeat.

Sentence-style capitalization needs more care because Excel does not have a built-in SENTENCE function. A formula can handle a simple one-sentence cell, but proper nouns, acronyms, multiple sentences, and unusual brand names still need review.

How to Convert Case in Excel: Quick Answer

Microsoft documents UPPER, LOWER, and PROPER as Excel's standard worksheet functions for changing capitalization. href="https://support.microsoft.com/en-us/excel/change-the-case-of-text" target="_blank" rel="noopener noreferrer" > Microsoft: Change the case of text in Excel .

Which Excel Case Conversion Method Should You Use?

Do not choose a method only because it looks shortest. Choose it based on what you need to do with the data afterward.

Method 1: Use UPPER, LOWER, and PROPER

Excel has three main built-in functions for basic capitalization changes. Add a temporary column next to the original data and apply the function there.

Convert lowercase text to uppercase

If your original value is in cell A2, enter:

=UPPER(A2)

Example:

Input: project alpha
Result: PROJECT ALPHA

Then drag or double-click the fill handle to apply the formula to the remaining rows.

Convert uppercase text to lowercase

Use:

=LOWER(A2)

Example:

Input: CUSTOMER SUPPORT
Result: customer support

Capitalize the beginning of each word

Use:

=PROPER(A2)

Example:

Input: john smith
Result: John Smith

PROPER is convenient, but do not assume the result is automatically correct for every person's name, company, abbreviation, or technical term.

How to Replace the Original Text Without Breaking It

A common Excel mistake happens after the formula works perfectly. Users delete the original column and discover that the converted cells depended on it.

The new column contains formulas such as:

=UPPER(A2)

It does not yet contain independent text — it still depends on cell A2.

To make the converted results permanent:

1. Select the converted cells.
2. Press Ctrl+C.
3. Choose Paste Special or the Paste menu.
4. Select Values.
5. Verify the pasted text.
6. Delete the old helper column only after checking the result.

This is the standard way to convert a formula's output into plain, independent text in Excel, so the result survives even after the source column is removed.

Method 2: Change Text Case with Flash Fill

Flash Fill is useful when your desired result follows a recognizable pattern and you do not want a worksheet formula.

Suppose A2 contains:

MUHAMMAD ALI

In B2, manually type:

Muhammad Ali

Then:

1. Press Enter after typing the example.
2. Select the next cell in the output column if needed.
3. Go to Data > Flash Fill, or press Ctrl+E on Windows.
4. Review several results before accepting the whole column as correct.

Microsoft describes Flash Fill as a feature that detects a pattern from the example you provide and fills the remaining data accordingly. href="https://support.microsoft.com/en-us/excel/using-flash-fill-in-excel" target="_blank" rel="noopener noreferrer" > Microsoft Flash Fill documentation .

When Flash Fill is especially useful

• reformatting names
• combining or separating text while changing capitalization
• cleaning one-time imports
• applying a pattern that is awkward to express with one formula

Flash Fill is pattern-based, so always inspect the output when the source data contains inconsistent formats.

Method 3: Create Simple Sentence Case in Excel

Excel does not provide a built-in SENTENCE function equivalent to its UPPER, LOWER, and PROPER functions.

For a simple single-sentence cell, you can use:

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

If A2 contains:

WELCOME TO THE NEW OFFICE

the result becomes:

Welcome to the new office

Important limitation

This formula changes characters mechanically. It does not understand language.

For example:

Input: WELCOME TO GOOGLE IN NEW YORK

could become:

Welcome to google in new york

That is not fully correct because Google and New York are proper names.

The formula also does not automatically capitalize the beginning of every new sentence inside a multi-sentence cell.

Use it when the data is simple and predictable. For prose containing names, brands, acronyms, or several sentences, review the result manually.

See our sentence case guide for capitalization rules and examples.

Method 4: Use Power Query for Repeatable Cleanup

Formulas are convenient for one worksheet. Power Query becomes more useful when the same data-cleaning process happens repeatedly.

A typical workflow is:

1. Select the source data.
2. Choose Data > From Table/Range.
3. Select the text column in Power Query.
4. Apply the required capitalization transformation.
5. Choose Close & Load.

Power Query's underlying text functions include:

• Text.Upper
• Text.Lower
• Text.Proper

Microsoft documents these transformations in its Power Query M text function reference. href="https://learn.microsoft.com/en-us/powerquery-m/text-functions" target="_blank" rel="noopener noreferrer" > Microsoft Power Query text functions .

The main advantage is repeatability. Once the transformation is part of the query, new source data can go through the same cleanup process when the query is refreshed.

Method 5: Use a Browser-Based Case Converter

A spreadsheet is not always the fastest workspace when you simply have a block of text that needs a different capitalization style.

You can copy the text, paste it into the CountFlows Case Converter, choose the required style, and paste the result back into Excel.

Available transformations include common options such as:

• UPPERCASE
• lowercase
• Title Case
• Sentence case
• other stylistic case transformations supported by the tool

CountFlows performs its text-tool processing in the browser rather than requiring the text to be sent to a text-processing API.

If the text you're pasting into Excel was copied from ChatGPT or another AI tool, it can carry Markdown symbols, invisible characters, or other formatting artifacts that interfere with PROPER, Flash Fill, or a sentence-case formula. Clean it first with the AI Text Cleaner, or see the guide to removing ChatGPT formatting for more methods.

Even after cleanup, treat automatic case conversion as a mechanical transformation. Check proper nouns, brand names, acronyms, and specialist terms after conversion.

Why Excel PROPER Can Produce Unexpected Capitalization

This is one of the most useful limitations to know before cleaning a large name list.

Microsoft explains that PROPER capitalizes the first letter in a string and letters that follow characters other than letters. It converts other letters to lowercase.

That behavior can create unexpected results in special text. Microsoft's own documentation shows this with 2-cent's worth, which PROPER converts to 2-Cent'S Worth — the letter right after the apostrophe gets capitalized too, since PROPER treats the apostrophe as a non-letter break point.

Microsoft documents this exact behavior in its href="https://support.microsoft.com/en-us/excel/proper-function" target="_blank" rel="noopener noreferrer" > PROPER function reference .

Does Changing Case Affect Numbers or Dates?

UPPER, LOWER, and PROPER are text functions. Non-letter characters inside a text string are not converted into uppercase or lowercase.

For example:

Input: invoice 2026-104
UPPER result: INVOICE 2026-104

The digits and hyphen remain while the letters change.

However, do not apply text-case formulas blindly to columns that contain real Excel dates, numeric values, IDs, or other data types. Excel stores dates internally as numbers, and converting data through text functions can change how the result behaves or displays.

Apply case conversion only to columns intended to contain text.

Common Problems When Changing Case in Excel

The formula appears instead of the result

The cell may be formatted as Text, or formula display may be enabled. Change the cell format to General if appropriate, then re-enter the formula.

You get a #NAME? error

Check the function spelling. For example:

Wrong: =UPER(A2)
Correct: =UPPER(A2)

The result disappears after deleting the source column

The converted cells still contain formulas linked to that source. Copy the results and paste them as values before removing the original data.

PROPER damages an acronym, brand name, or possessive

This is a limitation of mechanical capitalization. Correct exceptional names manually or use Find and Replace when the same term appears many times.

Flash Fill guesses the wrong pattern

Give Excel another example that better represents the desired result, or use a formula if the transformation follows a simple rule.

Sentence case lowercases proper names

A basic formula does not know that words such as Google, Pakistan, NASA, or iPhone have special capitalization. Restore those terms after the conversion or use a workflow designed for context-sensitive text.

The CountFlows 4-Point Case Conversion Check

Before replacing hundreds of original cells, inspect the converted output using four checks:

1. Pattern: Did the method apply the capitalization style you intended?
2. Exceptions: Are names, brands, acronyms, and technical terms still correct?
3. Data type: Did you limit the transformation to actual text rather than dates or numeric fields?
4. Replacement: If formulas were used, did you paste the final results as values before deleting the source column?

Checking a few rows at the top, middle, and bottom of a long dataset can catch pattern problems before they affect the entire worksheet.

Frequently Asked Questions

How do I capitalize all text in Excel?

Use =UPPER(A2) to convert a cell's text to all capital letters, then fill the formula down the column. Paste the results as values if you need to remove the original column afterward.

How do I use a case formula in Excel?

Enter the formula in a new cell referencing the text you want to convert — =UPPER(A2), =LOWER(A2), or =PROPER(A2) — then press Enter and drag the fill handle down to apply it to the rest of the column.

Can you convert uppercase to lowercase in Excel?

Yes. Use =LOWER(A2), where A2 is the cell containing the uppercase text. The result appears in the new cell without changing the original.

How do I change case in Excel without a formula?

Use Flash Fill. Type the result you want for the first cell manually, then select Data > Flash Fill or press Ctrl+E. Excel detects the pattern and fills the rest of the column automatically.

Bottom Line

For basic Excel text cleanup, start with UPPER, LOWER, or PROPER. Use Flash Fill when a pattern is easier to demonstrate than to write as a formula, and use Power Query when the same transformation needs to run repeatedly.

Sentence-style capitalization is more complicated because Excel has no dedicated sentence-case function and formulas cannot understand proper nouns or context automatically.

For quick copy-and-paste transformations, the CountFlows Case Converter provides another option. Whichever method you choose, review exceptional names and paste formula results as values before removing the original data.