Excel Formula: Capitalize Only the First Letter in Text

Formulas & functions · Updated November 18, 2026

To capitalize the first character in a cell and make the remaining characters lowercase, use =UPPER(LEFT(A2,1))&LOWER(MID(A2,2,LEN(A2))), assuming the text is in A2. If you want to capitalize just the first character while leaving the rest exactly as entered, use =UPPER(LEFT(A2,1))&MID(A2,2,LEN(A2)) instead.

Which formula should you use?

The right formula depends on what you mean by “only first letter capital.” The first option changes the entire cell to sentence-style casing: it makes the first character uppercase and every character after it lowercase. The second option changes only the first character, preserving the capitalization of the rest. Both return a result in the formula cell and leave the source cell unchanged.

For text in A2, the first option is useful for cleaning entries such as mARy sMITH into Mary smith. The second is better when the rest of the text may contain intentional uppercase letters, such as an acronym, product code, or name with unusual capitalization. It would turn hELLO NASA into HELLO NASA rather than Hello nasa.

Excel’s PROPER function is a different choice: it capitalizes the first letter of each word, not just the first character of the whole cell. That distinction matters for sentences, names, and phrases. The formulas above give you control over whether the rest of the text is converted or preserved.

How the formula works

With the source text in A2, the formula combines three text functions with Excel’s ampersand concatenation operator. LEFT extracts the first character, UPPER converts that character to uppercase, and MID takes the text beginning at the second character. LEN supplies the total character count so MID can return the remainder of the cell.

In the version that lowercases the rest, LOWER converts the extracted remainder before the ampersand joins it to the uppercase first character. In the version that preserves the remainder, MID is joined directly, with no LOWER conversion. For example, if A2 contains tHE QUICK FOX, the lower-rest formula returns The quick fox; the preserve-rest formula returns THE QUICK FOX.

With the source value in A2 as the text tHE QUICK FOX, this formula lowercases everything after the initial character and returns The quick fox:

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

With the same text in A2, this alternative preserves the remaining characters and returns THE QUICK FOX:

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

How to apply it to a column

In Microsoft Excel for Microsoft 365 on Windows, put the source text in one column and the formula in the neighboring column. For example, if names are in A2:A20, enter the formula in B2, then fill it down through B20. You can drag the fill handle at the lower-right corner of B2, or select B2:B20 and use Home > Fill > Down. Excel adjusts the relative reference from A2 to A3, A4, and so on.

With the source text in A2, this is the formula to enter in B2 before filling it down:

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

Check a few results before relying on the converted column. Compare the original and new values for names, abbreviations, and entries with punctuation. When the output is correct and you want to replace the original data, copy the formula results, then use Paste Special > Values in the destination column. This replaces formulas with their displayed text. Keep a copy of the original data until you have checked the results, because pasting values over the source removes the original entries.

The steps are substantially the same in Excel for Mac and Excel for the web: enter the formula in a neighboring cell and fill it down. Ribbon labels or the appearance of the fill handle can vary slightly by platform, but the formula syntax is the same. These formulas do not require a newer dynamic-array function; they work in older desktop versions of Excel as well as Microsoft 365.

Blank cells, spaces, and punctuation

An empty source cell normally produces an empty-looking result with the basic formula. A cell containing spaces is different: its first character is a space, so the formula may not visibly capitalize the first letter of the word. Punctuation at the start is also treated as the first character. If A2 begins with an opening quotation mark or a dash, the formula uppercases that punctuation, which has no visible effect; it does not skip ahead to capitalize the first alphabetic character.

If you want to remove extra spaces while converting the text, use TRIM around the source. With the entry in A2, this formula returns text with leading and trailing spaces removed, repeated ordinary spaces between words reduced to single spaces, and the first character capitalized:

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

TRIM changes the spacing, so do not use this version if spacing is meaningful or must be preserved. Excel’s TRIM is intended for ordinary spaces; it does not remove every possible nonprinting character or every kind of whitespace copied from websites. If imported text still looks misaligned or fails to match, it may contain nonbreaking spaces or other hidden characters that need separate cleaning.

To return a genuinely blank result when A2 is empty, including when A2 contains a formula returning an empty string, wrap the capitalization formula in IF. With the source in A2, use:

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

This blank check does not treat a cell containing only spaces as empty. If that distinction matters, clean or test the spaces deliberately rather than assuming an empty-cell check will catch them.

Why PROPER may not be the right answer

PROPER is often suggested when someone asks how to capitalize text in Excel, but its behavior is title-like: it makes the first letter of each word uppercase and other letters lowercase. With text in A2, the formula =PROPER(A2) changes john smith to John Smith, which is useful for many name lists. It would also change a sentence such as welcome to excel into Welcome To Excel, which is not normal sentence capitalization.

PROPER can also alter acronyms and names whose capitalization is intentional. For example, it may change NASA to Nasa and turn a brand or technical term into a form you do not want. It is not a universal name-correction tool, either: people’s names and organizations do not all follow the same capitalization pattern. Review converted records when accuracy matters.

With the text in A2, PROPER’s formula is:

=PROPER(A2)

Use PROPER when each word should begin with a capital letter. Use the UPPER, LEFT, MID, and LOWER combination when only the first character should be capitalized and the rest should be lowercase. Use the preserving version when changing the rest could damage meaningful capitalization.

Common problems and practical limits

  • The first visible letter did not change. Check whether the cell begins with a space, tab, or punctuation. The basic formula acts on character one, not the first letter it can identify.
  • An acronym became lowercase. The formula with LOWER deliberately converts the remainder. Switch to the version without LOWER if existing uppercase letters must survive.
  • A result appears as a formula or does not update. Check that the cell is not formatted as Text, and confirm that calculation is enabled. If a cell is formatted as Text, changing its format to General and re-entering the formula can resolve the issue.
  • The result is correct but the original column is unchanged. That is expected: formulas return results in their own cells. Copy the results and paste values if you need a fixed text column.
  • The formula shows an error. Make sure the source reference is correct and that parentheses and quotation marks are balanced. Excel formulas use the ampersand to join text; typing a plus sign instead will not perform the same text concatenation.

Capitalization functions do not determine whether a word is a person’s name, a proper noun, or an acronym. They apply consistent character rules. That is helpful for standardizing messy data, but it cannot replace a review when the correct spelling or brand styling matters.

Choosing between preserving and changing the rest

Before filling a formula down hundreds of rows, decide whether lowercase conversion is safe. For ordinary sentences entered with accidental mixed casing, converting the rest to lowercase often produces a readable result. For customer names, email addresses, part numbers, software identifiers, or imported labels, the preserved-rest version may be safer because it makes fewer assumptions.

Consider these examples when choosing:

  • mARIA: the lowercase-rest formula returns Maria; the preserving formula returns MARIA.
  • hELLO NASA: the lowercase-rest formula returns Hello nasa; the preserving formula returns HELLO NASA.
  • 123ABC: both formulas leave the first character as 1 and do not capitalize the later letters. The formula is based on position, not on finding the first letter.
  • aLICE with a leading space: the basic formulas act on the space. A TRIM-based version removes that leading space before converting the text.

These examples show why no single formula is best for every column. The first-letter-only request can mean either “make the first character uppercase and normalize the rest” or “change the first character, but touch nothing else.” Choose based on the data’s purpose, and preserve the source until you have reviewed the output.

Frequently Asked Questions

Can Excel capitalize only the first letter of a cell?
Yes. Use UPPER with LEFT to capitalize the first character. Add MID to return the rest of the text, and choose whether to wrap that remainder in LOWER. The formula affects the first character, so leading spaces or punctuation can affect what appears to be capitalized.

What formula capitalizes the first letter and lowercases the rest?
With the text in A2, use =UPPER(LEFT(A2,1))&LOWER(MID(A2,2,LEN(A2))). For mIXED CASE in A2, the result is Mixed case.

How do I capitalize only the first character and preserve the rest?
With the text in A2, use =UPPER(LEFT(A2,1))&MID(A2,2,LEN(A2)). This changes the first character but leaves every later character as it was, including existing uppercase letters.

Does PROPER capitalize just the first letter of a sentence?
No. PROPER capitalizes the first letter of each word. For sentence-style casing that changes only the first character of the cell and lowercases the remainder, use the UPPER, LEFT, MID, and LOWER formula instead.

Can I replace the original text with the formula result?
Yes. Fill the formula down, copy the resulting cells, and paste them as values into the destination. Check the results first and retain a backup of the source data if you may need to restore its original capitalization.

Will the formula capitalize the first letter after a space?
No. It capitalizes the first character of the entire cell, not the first character of every word or the first alphabetic character. Use PROPER for each word, or clean leading spaces first if the cell begins with unwanted spacing.

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.