Capitalize Only the First Letter in Excel (Sentence Case)

To capitalize the first letter in Excel and make the rest small, combine four functions: =UPPER(LEFT(A2,1))&LOWER(MID(A2,2,LEN(A2))). This is called sentence case, like "Order shipped today". Excel has no button or single function for it, so this formula is the standard fix. This guide explains each part, shows a version that leaves the rest of the text alone, and covers the spaces and other traps that stop it from working.

The sentence case formula#

The formula splits the text into the first character and everything after it, changes the case of each part, and joins them again.

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

LEN(A2) counts the characters in the cell. MID asks for that many characters starting at position 2, which is always enough to reach the end. Asking MID for more characters than exist is fine; it simply stops at the end of the text. The LEFT function guide, MID function guide and LEN function guide cover each function, and the article on LEFT, RIGHT and MID shows more ways to cut text apart.

How to use it on a whole column#

You can't change text in place with a formula, so work in a helper column and then replace the original.

1. In B2, type =UPPER(LEFT(A2,1))&LOWER(MID(A2,2,LEN(A2))) and press Enter.
2. Fill it down: double-click the fill handle, or select the range and press Ctrl+D (Mac: ⌘D).
3. Copy column B, then paste it over column A as values (Windows: Ctrl+Alt+V, then V, then Enter; Mac: ⌃⌘V, then choose Values).
4. Delete the helper column.

Notice row 4: "monday" stays small. The formula only knows about the first letter of the cell, not about names or days. Fix those by hand or with SUBSTITUTE.

How to capitalize the first letter but keep the rest#

Sometimes the rest of the text is already correct and contains capitals you want to keep, like NYC, iPhone or a product code. Leave out LOWER:

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

For "the NYC office is open", this returns The NYC office is open. The sentence case formula would return "The nyc office is open", which is wrong.

A shorter alternative uses REPLACE to swap only the first character:

=REPLACE(A2,1,1,UPPER(LEFT(A2,1)))

REPLACE starts at character 1, removes 1 character and puts the capital in its place. Use =REPLACE(LOWER(A2),1,1,UPPER(LEFT(A2,1))) for full sentence case.

Sentence case vs PROPER#

PROPER is the built-in function people try first, but it does something different. It capitalizes the first letter of every word.

Use PROPER for names and titles, and the sentence case formula for descriptions, notes and status messages. The guide to changing case with UPPER, LOWER and PROPER covers PROPER's quirks, such as the capital after an apostrophe.

Fix spaces before you capitalize#

If the text starts with a space, the formula capitalizes the space, and the first letter stays small. Data copied from emails, forms and web pages often has these hidden spaces. Wrap every A2 in TRIM:

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

For " late payment received ", the result is Late payment received, with the extra spaces gone. TRIM removes spaces at both ends and turns double spaces inside the text into single ones. The guide to cleaning messy data covers other invisible characters, and you can practise cleaning text in a live spreadsheet.

In Microsoft 365, the LET function can store TRIM(A2) once so you don't repeat it. The formula above works in every version.

Capitalize and join in one formula#

Because the result is just text, you can join it with other pieces using &. A common task is a display name such as "Priya S." from a first and last name typed in lower case:

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

With priya in A2 and sharma in B2, the result is Priya S.. The first part is the sentence case formula, then a space, then the first letter of the last name as a capital, then a full stop. The guide to getting initials from a name builds on the same LEFT trick, and how to combine text in Excel covers &, CONCAT and TEXTJOIN. Practise joining text to get quick with &.

Flash Fill: the no-formula option#

Flash Fill copies a pattern you type. In the column next to your text, type the first result the way you want it, such as "Order shipped today". Then press Ctrl+E on Windows, or use Data > Flash Fill on a Mac. Excel fills the rest of the column.

Flash Fill is fast for a one-time clean-up, but the results don't update if the original text changes, and it can guess the pattern wrong. Check a few rows. A formula is safer when the data will change or when a test asks for one.

Common mistakes#

These cause most sentence case problems:

1. Leading spaces. The first "character" is a space. Use TRIM.
2. Starting MID at 1. MID(A2,1,LEN(A2)) repeats the first letter: "Oorder shipped today". Start at 2.
3. Using PROPER. It gives title case, not sentence case.
4. Expecting more than one sentence to be fixed. The formula only capitalizes the first letter of the cell. A second sentence after a full stop stays small.
5. Checking case with =. In Excel, ="abc"="ABC" returns TRUE, because the equals sign ignores case. Use EXACT to check that the case really changed.

Practise it#

Sentence case uses four basic text functions at once, which makes it a great test of your text skills. Practise LEFT, RIGHT, MID and LEN in a live spreadsheet, then practise cleaning text: you type each formula and ExcelReady checks it instantly. Start with the display-name exercise on this page.