How to Change Text Case in Excel

Excel has no built-in case-change button, but you can use formulas to convert text to uppercase, lowercase, or proper case

If you have a column of names typed in all lowercase, or email addresses in mixed case, you cannot select the cells and click a menu option to fix them. Excel does not have a Format menu for text case. Instead, you use one of three formulas — UPPER(), LOWER(), or PROPER() — that convert text to the case you need. The formula goes in a new column, then you copy the results back over the original text if you want to replace it.

This takes about two minutes once you know which formula to use. The hardest part is usually deciding whether you want "John Smith" (proper case) or "john smith" (lowercase), because that choice determines which formula you pick.

Key Takeaways

UPPER() converts text to ALL CAPITALS, LOWER() converts to all lowercase, and PROPER() converts to Proper Case With Each Word Capitalized.
You write the formula in a new column next to your original text, then copy the results and paste them back as values to replace the original.
The formula syntax is simple: type =UPPER(A1) or =LOWER(A1) or =PROPER(A1), where A1 is the cell containing the text you want to change.
After you paste the converted text back over the original, delete the helper column with the formulas.

Using UPPER() to convert text to all capitals

The UPPER() formula converts every letter in a cell to a capital letter. Use this when you need all-caps text like "INVOICE" or "URGENT" or when you are standardizing a list of codes.

Click on an empty cell next to your text — if your names are in column A, click a cell in column B. Type =UPPER(A1) and press Enter. Excel converts the text in A1 to capitals and shows the result in B1. If your text starts in A2 instead of A1, type =UPPER(A2). The number always matches the row you are converting.

Now copy this formula down the entire column. Click B1 again, then grab the small square at the bottom-right corner of the cell and drag it down to the last row of your data. Excel copies the formula to every row and adjusts the cell reference automatically — B2 will say =UPPER(A2), B3 will say =UPPER(A3), and so on.

Using LOWER() to convert text to all lowercase

The LOWER() formula converts every letter to lowercase. Use this for email addresses, usernames, or any text that needs to be all lowercase.

Click an empty cell next to your text and type =LOWER(A1), then press Enter. Copy the formula down to all your rows the same way you did with UPPER() — click the cell, grab the corner, and drag down. Every piece of text in column A now has a lowercase version in column B.

LOWER() is especially useful for email addresses, because email systems treat uppercase and lowercase the same way, but having consistent lowercase makes lists easier to read and compare.

Using PROPER() to convert text to title case

The PROPER() formula capitalizes the first letter of each word and makes the rest lowercase. This is the most common choice for names and titles — "John Smith" instead of "john smith" or "JOHN SMITH".

Click an empty cell and type =PROPER(A1), then press Enter. Copy the formula down to all your rows. PROPER() works on any text, so you can use it on job titles, company names, or product descriptions.

One thing to watch: PROPER() capitalizes the first letter after any space or punctuation. If you have a name like "O'Brien", PROPER() will make it "O'brien" with a lowercase B. If that happens, you will need to fix those cells by hand, or use Find and Replace to fix the pattern across the whole column.

Copying the converted text back to replace the original

Once your formulas have converted all the text, you need to copy the results and paste them back over the original column as values only — not as formulas. If you just copy the formulas over, you will create a circular reference and Excel will show an error.

Click the column header of your formula column (B, in this example) to select the entire column. Press Ctrl+C to copy. Now click the column header of your original text (A) and press Ctrl+V to paste. Excel will ask you what you want to paste. Click the clipboard icon that appears and choose "Values Only" or "Paste Special" and select "Values". This pastes only the text, not the formula.

Now your original column contains the converted text, and your formula column still contains the formulas. You can delete the formula column — right-click the column header and click Delete Column.

Fixing common mistakes when using case formulas

The most common mistake is forgetting to copy the formula down to all rows. If you type =UPPER(A1) and press Enter but do not drag the formula down, only the first cell gets converted. Check that your formula column has the same number of rows as your original text.

Another mistake is pasting the formulas back as formulas instead of values. If you do this, the original column will show the formula text (=UPPER(A1)) instead of the converted text. Undo this with Ctrl+Z and paste again, this time choosing "Values Only".

If PROPER() capitalizes letters you did not want capitalized — like the B in "O'Brien" — you will need to fix those by hand. There is no formula that handles every exception to English capitalization rules. Select the cells that need fixing and type the correct text directly.

Using case formulas on data you receive from other sources

When you import data from another program or receive a spreadsheet from someone else, the text is often in inconsistent case. One row might say "john smith", the next "JOHN SMITH", the next "John Smith". Running PROPER() on the entire column standardizes it in one step.

The same applies to email addresses or product codes that arrive in mixed case. Run LOWER() on the whole column to make them consistent. This is especially useful before you use the data for lookups or comparisons, because Excel treats "Smith" and "smith" as different text in most functions.

If you receive data regularly and need to convert case every time, you can keep the formula column in your spreadsheet and just update it with new data. Delete the old text, paste the new text in column A, and the formulas in column B update automatically.

Frequently Asked Questions

Can I change case without using a formula?

No. Excel has no menu option or button to change text case. You must use a formula. The formulas are fast and work on hundreds of rows at once, so it is quicker than trying to find another method.

What if I only want to change case for some cells, not the whole column?

Use the formula only on the cells you need to change. Click an empty cell next to the first cell you want to convert, type the formula, press Enter, then copy it down only to the last cell you need. Leave the rest of the column empty.

Will the formula change if I edit the original text later?

Yes, as long as the formula is still there. If you change "john" to "jane" in A1, the formula in B1 automatically updates to show "JANE" or "Jane" depending on which formula you used. Once you paste the results back as values and delete the formula column, changes to the original text will not affect the converted text.

Can I use these formulas on numbers or mixed text and numbers?

UPPER(), LOWER(), and PROPER() work on text only. If a cell contains a number, the formula returns the number unchanged. If a cell contains both text and numbers like "Item123", the formula converts only the text part and leaves the numbers as they are.

What if I accidentally delete the formula column before pasting the results back?

Undo with Ctrl+Z immediately. If you have already done other work, undo multiple times to get back to the point where the formula column still existed. If you cannot undo, you will need to recreate the formulas and start over.

This guide is for general information only and is not medical, financial, legal, or other professional advice. For decisions specific to your situation, consult a qualified professional. See our Editorial Policy.