Excel Formula to Capitalize Text: UPPER, PROPER, LOWER

Formulas & functions · Updated November 22, 2026

The quickest way to capitalize text in Excel is with the UPPER function (all caps), the PROPER function (first letter of each word capitalized), or the LOWER function (all lowercase). For example, =UPPER(A1) turns “hello world” into “HELLO WORLD”, =PROPER(A1) turns it into “Hello World”, and =LOWER(A1) turns it into “hello world”.

Why Excel Doesn’t Have a One-Click Capitalize Button

Unlike word processors such as Microsoft Word, Excel does not have a built-in “Change Case” button on the ribbon. The reason is that Excel treats text as data, not as a document to be formatted. Changing the case of a cell’s text changes its value, which can break formulas, lookups, and data validation. So Microsoft provides functions instead, which give you full control over whether the change is permanent or just for display.

The Three Core Functions: UPPER, LOWER, and PROPER

These three functions are the foundation of any case conversion in Excel. They are simple, reliable, and work in every version of Excel from 2007 through Microsoft 365, as well as Excel for the web and Excel for Mac.

  • UPPER(text) – Converts all letters to uppercase. Example: =UPPER("excel") returns EXCEL.
  • LOWER(text) – Converts all letters to lowercase. Example: =LOWER("EXCEL") returns excel.
  • PROPER(text) – Capitalizes the first letter of each word and lowercases the rest. Example: =PROPER("hello WORLD") returns Hello World.

Each function takes exactly one argument: a text string, a cell reference, or a formula that returns text. The functions ignore numbers and punctuation, so =PROPER("123 main st.") returns 123 Main St.

How to Apply the Formula Step by Step

Here is the standard workflow for converting a column of names from lowercase to proper case:

  1. Assume your original text is in cells A2:A100.
  2. Click on cell B2.
  3. Type =PROPER(A2) and press Enter.
  4. Drag the fill handle (the small square at the bottom-right corner of B2) down to B100.
  5. Check the results, then copy column B and use Paste Special > Values (right-click > Paste Special > Values) to replace the original data if you no longer need the lowercase version.

If you want to keep the original data intact, leave the formulas in column B. If you want to replace the original, the Paste Special > Values step is essential—otherwise, deleting column A will break your formulas.

Common Problems and Misconceptions

One frequent issue is that PROPER capitalizes every word, including prepositions like “of” or “the”. For example, =PROPER("the lord of the rings") returns The Lord Of The Rings, which is not how titles are usually styled. There is no built-in function to handle title case exceptions; you would need a more complex formula or a macro.

Another common misconception is that changing the font to “small caps” or using a custom number format will change the actual text. It will not. Formatting only changes how the text looks; the underlying value remains unchanged. If you need the text itself to be capitalized, you must use a function or a macro.

Also note that PROPER treats apostrophes and hyphens as word boundaries. So =PROPER("o'brien") returns O'Brien, and =PROPER("state-of-the-art") returns State-Of-The-Art. This is usually what people want, but it is not always correct for names like “McDonald” (which becomes “Mcdonald”).

Flash Fill: The No-Formula Alternative

If you prefer not to write formulas, Excel’s Flash Fill (introduced in Excel 2013) can detect a pattern and fill the rest of a column automatically. For example, if you type “john smith” in A2 and then type “John Smith” in B2, select B2, press Ctrl+E (Windows) or Cmd+E (Mac), and Excel will fill the rest of column B with proper-case versions of column A.

Flash Fill works best when your data is consistent. It does not update automatically if you change the source data later—it is a one-time action, not a live formula. For dynamic updates, stick with PROPER.

Comparing UPPER, PROPER, and LOWER with Real Data

Suppose you have a list of email addresses in A2:A5: JOHN.DOE@EXAMPLE.COM, jane_smith@example.org, Bob@Example.net, and ALICE@example.co. If you want to normalize them to lowercase for a mailing list, use =LOWER(A2) in B2 and copy down. The result will be john.doe@example.com, jane_smith@example.org, bob@example.net, and alice@example.co.

If you want to display them as proper names, =PROPER(A2) would give John.Doe@Example.Com, which is wrong for email addresses because it capitalizes the domain. That is why you must choose the function based on the type of text you are dealing with.

Frequently Asked Questions

Can I capitalize only the first letter of a sentence in Excel? Yes, but not with a single built-in function. You can combine UPPER, LEFT, and RIGHT. For text in A1, use =UPPER(LEFT(A1,1))&LOWER(RIGHT(A1,LEN(A1)-1)). This capitalizes the first character and lowercases everything else. It does not handle multiple sentences within one cell.

Does PROPER work with accented characters? Yes. =PROPER("éclair") returns Éclair. The function respects Unicode letters, so it works with French, German, Spanish, and other accented text. However, it does not handle ligatures or special casing rules like the German ß (which becomes SS in uppercase in some contexts).

How do I capitalize text without a formula? Use Flash Fill as described above, or use Power Query (Data > From Table/Range) and transform the column using the “Capitalize Each Word” option under Transform > Format. Power Query is useful for large datasets and can be refreshed when the source data changes.

Why does my PROPER formula return #VALUE! This error occurs if the argument is a number, not text. For example, =PROPER(123) returns #VALUE!. Convert the number to text first with =PROPER(TEXT(123,"0")) or use =PROPER(A1&"") if A1 contains a number.

Is there a macro to capitalize a whole selection? Yes, you can use VBA. Press Alt+F11 to open the editor, insert a module, and paste this code:

Sub CapitalizeSelection()
    Dim cell As Range
    For Each cell In Selection
        If cell.Value <> "" Then
            cell.Value = StrConv(cell.Value, vbProperCase)
        End If
    Next cell
End Sub

Save a copy of your workbook before running any macro, because macros cannot be undone with Ctrl+Z. This macro converts each selected cell to proper case in place.

Safety and Data Integrity Tips

Before applying any case transformation to a large dataset, always make a backup copy of the original file. If you use formulas, keep the original data in a separate column so you can verify the results. If you use Paste Special > Values to overwrite the original, double-check a few rows manually—especially names with apostrophes, hyphens, or unusual capitalization like “McDonald” or “iPhone”.

Also be aware that UPPER, LOWER, and PROPER are volatile only in the sense that they recalculate when the source cell changes; they are not volatile like NOW(). They have no side effects on other cells. For most business data, using PROPER on names and LOWER on email addresses is a safe, reversible step if you keep the original column.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

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

Spotted an error in this guide? Let us know.