Excel UPPER, LOWER, and PROPER functions for changing text case
In Excel, use UPPER to make letters uppercase, LOWER to make them lowercase, and PROPER to capitalize the start of each word. Each formula returns new text in its own cell and leaves the source cell intact.
Pass text to each function
Inside the parentheses, use a cell reference such as A2 or enter text in double quotation marks. To compare the functions, type the following formulas one at a time in B2, C2, and D2, respectively.
=UPPER(A2)
=LOWER(A2)
=PROPER(A2)
See the function syntax in Microsoft Support.
Compare results for the same inputs
Type the first column of the table into A2 through A4. Fill the three formulas down from B2:D2 through row 4. Each row will apply all three functions to its own input.
| Original text | UPPER | LOWER | PROPER |
|---|---|---|---|
abCdE |
ABCDE |
abcde |
Abcde |
12-aBc |
12-ABC |
12-abc |
12-Abc |
NASA report |
NASA REPORT |
nasa report |
Nasa Report |
Use UPPER or LOWER when a column needs consistent capitalization. The sample results show that digits, spaces, and hyphens stay in place. PROPER treats punctuation and other nonletters as boundaries, so it may capitalize letters inside a code.
What PROPER does to names and acronyms
PROPER capitalizes the first letter and any letter that follows a nonletter. It converts the other letters to lowercase. In 12-aBc, for instance, it capitalizes the a after the hyphen. The same rule applies to a letter immediately after a digit.
NASA report comes out as Nasa Report. Check acronyms, surnames, and brand names before accepting the results across a column. The function applies a casing rule, so it cannot infer an organization’s preferred spelling.
Replace the source with fixed values
- Enter the function you want in an empty helper column next to the source, then fill it down to the last data row. Keep a copy of the original column or workbook if you might need to restore it.
- Compare the first and last results with the original, and spot-check rows with acronyms and punctuation. These formulas change the characters in the string itself, so they affect later searches and exports that use the converted values.
- Copy the helper column’s results. Select the first data cell of the original column and choose Values from Paste Options. Check the formula bar for the converted text. Once pasted as values, the results are fixed and no longer recalculate.
To compare two strings with case taken into account, use the following function. How to use Excel’s EXACT function




