Excel First Letter Uppercase Rest Lowercase?

How-to basics · Updated November 22, 2026

Yes, Excel can change the first letter of each word to uppercase and the rest to lowercase, but there is no single built-in button for it. The standard method is the PROPER function, which converts text so that the first letter of every word is capitalized and all other letters are lowercase. For example, =PROPER("hELLO wORLD") returns Hello World. If you only want the very first letter of a cell capitalized and all others lowercase (not per word), you need a slightly different formula, shown below.

Why Excel Doesn’t Have a One-Click Fix

Unlike Word, which has a Change Case menu, Excel’s ribbon has no direct “Sentence case” or “Capitalize Each Word” command. The core reason is that Excel treats text as data, not as document content. Changing case could alter values used in lookups, comparisons, or formulas, so Microsoft leaves case conversion to functions. The three built-in text functions are:

  • UPPER() – converts all letters to uppercase.
  • LOWER() – converts all letters to lowercase.
  • PROPER() – capitalizes the first letter of each word, lowercases the rest.

These functions have existed for decades and work in every version of Excel, including Excel for the web and Excel on Mac.

How to Use PROPER for First Letter Uppercase

Assume you have names in column A, starting at A2. In B2, enter:

=PROPER(A2)

Then drag the fill handle down. For a list with “john SMITH” in A2, the formula returns “John Smith”. If A2 contains “O’BRIEN”, PROPER returns “O’Brien” because it treats the apostrophe as a word boundary – that is usually desirable for names, but it also means “don’t” becomes “Don’T”.

To replace the original data with the converted text, copy column B, then use Paste Special > Values over column A, and delete column B.

Capitalizing Only the First Letter of the Cell

If you want “hELLO wORLD” to become “Hello world” (only the first letter uppercase, all other letters lowercase), PROPER won’t do it because it capitalizes every word. Instead, combine UPPER, LOWER, and LEFT:

=UPPER(LEFT(A2,1)) & LOWER(RIGHT(A2,LEN(A2)-1))

With A2 containing “hELLO wORLD”, this returns “Hello world”. The formula takes the first character, uppercases it, then takes the rest of the string (from character 2 onward), lowercases it, and joins them with the ampersand. This works in all Excel versions.

Using Flash Fill for Quick Conversion

Excel’s Flash Fill (introduced in Excel 2013) can do the same without formulas. Type the desired result in the cell next to your data, then press Ctrl+E (Windows) or Cmd+E (Mac) to fill the pattern. For example, if A2 is “hELLO wORLD”, type “Hello world” in B2, select B2, and press Ctrl+E. Excel will fill the rest of column B based on the pattern. Flash Fill is not a formula, so if you change the source data, the converted text won’t update automatically. Also, Flash Fill can be unpredictable with inconsistent data, so always check the results.

Common Problems and Misconceptions

A frequent mistake is assuming PROPER handles all names correctly. It does not handle surnames like “McDonald” or “van der Berg” properly – it will produce “Mcdonald” and “Van Der Berg”. There is no built-in way to fix these exceptions; you must manually correct them or use a more complex formula with SUBSTITUTE for specific prefixes.

Another issue: PROPER lowercases letters that are intentionally uppercase, such as acronyms. “NASA” becomes “Nasa”. If you need to keep acronyms, you’ll need a VBA macro or a manual review.

Also, note that PROPER treats numbers and punctuation as word separators. So “123abc” becomes “123Abc”, and “hello-world” becomes “Hello-World” (the hyphen triggers a new word). This is usually fine, but it can surprise you with product codes.

Alternatives: Power Query and VBA

For large datasets, Power Query (Get & Transform) offers a non-formula approach. Go to Data > From Table/Range, select the column, then Add Column > Format > Capitalize Each Word. This applies the same logic as PROPER but inside the query. Load the result back to a worksheet. Power Query is available in Excel 2016 and later, including Microsoft 365.

If you need full control (e.g., handling exceptions or acronyms), a small VBA macro can do it. Here is a simple example that capitalizes the first letter of each word but leaves existing uppercase letters untouched:

Sub CapitalizeFirstLetter()
    Dim cell As Range
    For Each cell In Selection
        If cell.Value <> "" Then
            ' Split into words, capitalize first letter, keep rest as-is
            Dim words() As String
            Dim i As Integer
            words = Split(cell.Value, " ")
            For i = LBound(words) To UBound(words)
                If Len(words(i)) > 0 Then
                    words(i) = UCase(Left(words(i), 1)) & Mid(words(i), 2)
                End If
            Next i
            cell.Value = Join(words, " ")
        End If
    Next cell
End Sub

Before running this macro, save a copy of your workbook, because macros cannot be undone with Ctrl+Z. To use it, press Alt+F11 to open the VBA editor, insert a module, paste the code, then run it on a selected range. This macro preserves original uppercase letters in the middle of words, which PROPER does not.

Frequently Asked Questions

How do I capitalize the first letter of each word in a column?

Use =PROPER(A2) in a helper column, then copy and paste as values. This is the simplest method and works for most names and titles.

Why does PROPER turn “McDonald” into “Mcdonald”?

Because PROPER only capitalizes the first letter after a space or punctuation. It has no knowledge of name prefixes. You can manually correct such cells or use a formula that checks for common prefixes like =IF(LEFT(A2,2)="Mc", "Mc" & PROPER(MID(A2,3,99)), PROPER(A2)).

Does Flash Fill update automatically?

No. Flash Fill creates static values, not formulas. If you change the original data, the converted text will not update. Use a formula if you need dynamic results.

Can I change case without a formula in Excel?

Yes, Flash Fill (Ctrl+E) is the only built-in non-formula method. Power Query also works without formulas if you load data into the query editor.

Is there a keyboard shortcut for PROPER?

No. There is no direct shortcut for case conversion. You must type the formula or use Flash Fill. The only related shortcut is Ctrl+E for Flash Fill.

Does PROPER work with numbers and special characters?

Yes, but it treats them as word separators. For example, “123abc” becomes “123Abc”. If you need to keep numbers untouched, you’ll need a more complex formula or VBA.

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.