Excel has three case functions. =UPPER(A1) makes everything capitals, =LOWER(A1) makes everything lowercase, and =PROPER(A1) capitalises the first letter of each word. There’s no sentence-case function, so for that you build it: =UPPER(LEFT(A1,1))&LOWER(RIGHT(A1,LEN(A1)-1)) capitalises the first letter and lowercases the rest.
All four return text in a new cell rather than changing the original, so once you’re happy, copy the results and paste them back over the source as values. Two things worth knowing.
PROPER capitalises after any non-letter, so “o’brien” becomes “O’Brien” (right) but “don’t” becomes “Don’T” (wrong), and it also flattens acronyms — “USA” becomes “Usa”. And an empty cell returns #VALUE! with the sentence-case formula, because LEN(A1)-1 goes negative; wrap it in =IFERROR(...,"") if blanks are possible.
For a one-off conversion with no formula, type the corrected version next to the first row and press Ctrl+E for Flash Fill.
In Excel, there are three primary functions that you can use to change the case for a string.
- UPPER for changing the case to upper.
- LOWER for changing the case to lower.
- PROPER for changing the case so that the first letter of each word is a capital letter.
In this tutorial, we will learn to use all these functions to write our formulas.
UPPER CASE
In Excel, there is a function with the name UPPER which allows you to change the case of a string into UPPER (Capital).

In the above example, column A has different strings (text values). And when you use UPPER and refer to the cell, it converts that value into an upper-case text.
=UPPER(A1)
LOWER CASE
In the same way, you also have a function with the name LOWER to convert a text into lower-case text.

In the above example, when we use the “Lower” function, we get all the characters of the result in lower case. This function works exactly opposite to the “Upper” function we used in the first example.
=LOWER(A1)
PROPER CASE
And then, we have the PROPER function, which converts a text into a proper case where the first letter in each word is a capital letter and the rest are in lower case.

=PROPER(A1)
You can see in the above example that the first letter of the word is a capital letter, and the rest are small. And if you have two words, it works in the same way.
But PROPER treats every character that isn’t a letter as the end of a word. So, it capitalizes the letter after an apostrophe or a number: “don’t stop” becomes “Don’T Stop” and “2nd floor” becomes “2Nd Floor”. Check names and text like this after you use PROPER.

And if you want the first letter of the first word as a capital letter, and the rest of the letters and all the other words in lower case (sentence case), you can use the formula below.

=UPPER(LEFT(A1,1))&LOWER(RIGHT(A1,LEN(A1)-1))
This formula returns the #VALUE! error for a blank cell, as LEN(A1)-1 becomes -1. To leave blank cells blank, use this version instead:
=IF(A1="","",UPPER(LEFT(A1,1))&LOWER(MID(A1,2,LEN(A1))))
And if you only want to capitalize the first letter and keep the rest of the text as it is (like names or abbreviations inside the sentence), leave out LOWER:
=UPPER(LEFT(A1,1))&MID(A1,2,LEN(A1))
Change Case without a Formula (Flash Fill)
Excel doesn’t have a Change Case button like Word, but Flash Fill (Excel 2013 and later) can do it without a formula:
- First of all, in the column next to your data, type the first value the way you want it, like “JOHN SMITH”.
- After that, select the next cell below it.
- In the end, press Ctrl + E (or go to Data ➜ Flash Fill), and Excel fills the rest of the column in the same case.
Flash Fill gives you fixed values, so it doesn’t update when the original data changes.
Replace the Original Text with the New Case
The formulas give you the result in a new column. To replace the original text, copy the formula column, select the original column, and use Paste Special ➜ Values (Ctrl + Alt + V, then V and Enter). After that, you can delete the formula column.
If you work with Power Query, you can also change the case there: select the column and go to Transform ➜ Format ➜ lowercase, UPPERCASE or Capitalize Each Word.
Frequently Asked Questions
Is there a shortcut to change case in Excel?
No. Shift + F3, which changes case in Word, doesn’t do that in Excel. Use the UPPER, LOWER or PROPER functions, or Flash Fill (Ctrl + E).
Do these functions change numbers?
No. UPPER, LOWER and PROPER only change letters. Numbers and symbols stay as they are, but the result is a text value, so a number in the result is stored as text.
How do I check if a cell is all capital letters?
Compare the cell with its upper-case version using EXACT, which is case-sensitive. It returns TRUE when all the letters are capitals:
=EXACT(A1,UPPER(A1))
Written by
Puneet Gogia
Microsoft MVP — Excel · Founder, Excel Champs
Twelve years of teaching Excel, and a decade before that using it as a data analyst. Every tutorial here is written from a file I actually built.