Excel Format Text: Uppercase, Lowercase, and Proper Case

How-to basics · Updated November 18, 2026

Excel’s cell-format settings cannot convert text to uppercase or lowercase; use the UPPER, LOWER, or PROPER function to create a converted result. For a one-time change, Flash Fill or Power Query can also produce converted text, but the right choice depends on whether the result should update when the original text changes.

What Excel’s text formatting can—and cannot—do

In Excel, formatting usually changes how a value looks without changing the value itself. Number formats can display a date differently or add a currency symbol, while font settings can change a cell’s typeface, size, or color. There is no built-in setting in Format Cells that changes the capitalization of the letters stored in a text value.

That distinction matters when you are looking for an option such as a lowercase or uppercase switch in the ribbon. Selecting cells and using Home > Format Cells, or opening the Format Cells dialog, will not convert their text case. A custom number format also cannot turn existing letters into uppercase or lowercase.

Instead, Excel’s case-conversion functions return text in a new result. You can keep the original column and put the converted version next to it, or replace the original values with the results after checking them. This approach makes the change clear and helps prevent accidental loss of source data.

Convert text with UPPER, LOWER, and PROPER

These three functions cover the common capitalization changes. Enter a formula in a neighboring cell, then fill it down for the other rows. The examples below assume the source text is in A2; the displayed result is what the formula returns for the sample input.

  • UPPER changes letters to uppercase. With the text North region in A2, enter =UPPER(A2) in B2; the result is NORTH REGION.
  • LOWER changes letters to lowercase. With North Region in A2, enter =LOWER(A2) in B2; the result is north region.
  • PROPER capitalizes the first letter of each word and makes the other letters lowercase. With nORTH rEGION in A2, enter =PROPER(A2) in B2; the result is North Region.

These functions return text, so they work well for names, labels, addresses, and other text values. They do not change punctuation or correct spelling. PROPER is a capitalization rule, not a name-aware editor: it may produce an unwanted result for acronyms, product names, or surnames with unusual capitalization. For instance, a brand that deliberately uses mixed case may need to be corrected separately after conversion.

To apply a formula to a column, select the cell containing the formula and use the fill handle at its lower-right corner to fill down. Review the output before replacing anything. Formula results depend on the source cells, so a correction to A2 will update a formula result that refers to A2.

Turn formula results into fixed text

If you want the converted values to stand alone instead of updating with the original column, copy the results and paste them as values. First make sure the output looks right, then select and copy the converted cells. Use Home > Paste > Values to put the results in a destination range. The pasted cells contain text rather than formulas.

For example, you might use a temporary column to standardize a list of customer names, check the spelling and capitalization, then copy those results and paste values over the original names. Keeping an untouched copy of the source column until you have verified the replacement is a sensible safeguard, especially for a large list.

Do not simply delete the source column while formulas still refer to it. Depending on how you delete or move the cells, the formulas may return errors or change their references. Paste values into the intended destination first, confirm the result, and only then remove any temporary columns you no longer need.

Case conversion and case-sensitive comparisons

Changing how a value is capitalized is different from changing how Excel compares text. Many everyday Excel comparisons and lookups treat text case-insensitively: for example, ordinary comparisons generally regard East and EAST as equivalent. Converting a column to uppercase is therefore not automatically necessary just to make a typical lookup work.

There are exceptions when the distinction between uppercase and lowercase matters. The EXACT function compares two text strings with case sensitivity, and some specialized formulas or data-cleaning processes may need to preserve or inspect letter case. If a source system uses capitalization to distinguish codes, changing the case could erase meaningful information. Check what the values represent before standardizing them.

Also, a formula that changes case does not edit the original cell. If A2 contains East and B2 contains a UPPER formula referring to A2, A2 remains East while B2 displays EAST. This is often useful: the source stays available for comparison while the new column provides a consistent format.

Use Flash Fill for a one-time pattern

Flash Fill can recognize a pattern from an example and fill the rest of a column with matching results. It is useful when you want a quick, fixed output and do not need the result to stay linked to the source. For example, put a name in the desired case in the first output cell, then use the same pattern for another example if needed. Select the output range and choose Data > Flash Fill. In Excel for Windows, Ctrl+E is the Flash Fill shortcut.

Flash Fill is pattern-based rather than a general rule that guarantees every result is appropriate. Inspect the filled column, particularly if the source contains initials, hyphenated names, abbreviations, or inconsistent spacing. It produces values rather than formulas, so editing the original source later will not automatically update the filled results.

If Flash Fill does not appear to infer the pattern, provide another example or use UPPER, LOWER, or PROPER instead. The menu command is available in desktop Excel; when working in another Excel version, availability and controls may differ. Formula conversion is the more predictable option when the rule is simply to make every letter uppercase or lowercase.

Use Power Query for repeatable imports

Power Query is useful when you regularly import or combine data and want the same case-cleaning step to run again on refresh. In Excel for Microsoft 365 on Windows, select a cell in the source table and choose Data > From Table/Range to open the Power Query Editor. Select the text column, then use Transform > Format and choose lowercase, UPPERCASE, or Capitalize Each Word.

After applying the transformation, choose Home > Close & Load to return the query results to Excel. The query keeps the conversion as a step, so when you refresh the query with updated source data, Excel can apply that transformation again. The result is not the same as a worksheet formula tied directly to each source cell; it is part of the query’s import-and-transform process.

Power Query is more setup than a formula for a few cells, but it is helpful for recurring reports, repeated file imports, or several columns that need consistent cleanup. Review the transformed output before relying on it, and keep the source data unchanged when you need an auditable record of what was imported.

Choose the method that fits the job

The main decision is whether you need a live relationship to the source, a quick one-time result, or a repeatable import step. Use the method that matches how the workbook will be maintained:

  • Use a formula when the converted result should update as the source cell changes, or when you want to inspect the original and converted text side by side.
  • Paste values after using a formula when you want a fixed result and no longer need the formula link.
  • Use Flash Fill for a quick, one-time pattern that you can check manually.
  • Use Power Query when the same conversion should be part of a repeatable data-import or refresh process.

For a short list of names, a formula is usually easiest to verify. For a recurring monthly export, Power Query can save repeated manual work. For a one-off cleanup, Flash Fill may be convenient, but it is still important to scan the results for exceptions. None of these methods can determine whether a particular company, acronym, or person’s name has a preferred capitalization; that requires checking the source or applying corrections.

Common problems and how to avoid them

A frequent mistake is changing a cell’s font or number format and expecting the letters themselves to change. Those settings affect appearance, not the text content. Use a case function or one of the conversion tools instead.

Another issue is assuming PROPER produces correct capitalization for every name. It applies a general title-style pattern, which can turn acronyms into mixed case and may not match the preferred spelling of a person’s name or brand. If the exact spelling matters, use PROPER only as a first pass and review exceptions manually.

Be careful when replacing source data. Formulas can be overwritten or removed, while Flash Fill creates values that do not track later edits. Keep a backup or original column until you have checked the converted data. If the cells contain leading or trailing spaces or inconsistent separators, case conversion alone will not clean those problems; they need separate cleanup.

Finally, remember that Excel’s capitalization functions affect letters, not the meaning of the text. They will not translate words, standardize abbreviations intelligently, or validate that a value is a real name. A neat-looking column is not necessarily a verified one.

Frequently Asked Questions

Can I change text to uppercase from Format Cells?

No. Format Cells does not include a setting that converts text to uppercase or lowercase. Use the UPPER or LOWER function, Flash Fill, or a Power Query text-format transformation.

How do I make all text lowercase in Excel?

If the original text is in A2, enter =LOWER(A2) in another cell and fill the formula down. Copy the results and paste values if you want fixed text instead of formulas.

How do I capitalize the first letter of each word?

Use PROPER on the source cell. For text in A2, =PROPER(A2) returns each word with an initial capital and the remaining letters lowercase. Check names and acronyms because the function cannot know their preferred spelling.

Will changing case alter the original cell?

No. A formula in a different cell returns a converted result and leaves the source untouched. To replace the original, copy the converted results and paste them as values into the destination after checking them.

Does Excel treat uppercase and lowercase text as different?

Most ordinary Excel text comparisons are not case-sensitive, so capitalization alone often does not affect a comparison or lookup. Some functions, including EXACT, do distinguish case; check the behavior of the specific operation you are using.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.