How to Change Text Case in Excel — Three Methods That Work

The fastest way to change case in Excel

Excel has no built-in button to change text case the way Word does. Instead, you use a formula. The three formulas that work are UPPER() to make text all capitals, LOWER() to make it all lowercase, and PROPER() to capitalize the first letter of each word. You type the formula in a new column, copy it down for all your text, then paste the results back as values over your original data.

The whole process takes about two minutes. You do not need to install anything or use a macro — these formulas are built into every version of Excel.

Key Takeaways

UPPER(), LOWER(), and PROPER() are the three formulas that change text case; PROPER() capitalizes the first letter of each word, which is what most people need.
You enter the formula in a new column next to your data, then copy it down to match the number of rows you have.
After the formula produces the new text, you copy the results and paste them as values only back into your original column to replace the old text.
If you have thousands of rows, this method is faster and more reliable than doing it manually or searching for a third-party tool.

Using PROPER() to capitalize the first letter of each word

PROPER() is the formula most people need. It takes text like "john smith" or "JOHN SMITH" and turns it into "John Smith" — capital first letter of each word, lowercase for the rest.

Open your spreadsheet and click on an empty column next to your data. In the first cell of that column, type =PROPER(A1) if your text is in column A, row 1. Press Enter. The formula will show the corrected text in that cell.

Now click back on that cell and copy the formula down to every row that has text. The fastest way: click the cell, then double-click the small square at the bottom right corner of the cell. Excel will automatically copy the formula down to match the rows above it. If that does not work, click the cell, hold Shift, and click the last row with data, then press Ctrl+D to fill down.

Once all the new text appears in the new column, select all of it, copy it, then right-click on your original column and choose Paste Special. Click Values and then OK. This replaces your old text with the new case-corrected text. You can then delete the helper column.

Using UPPER() to convert text to all capitals

UPPER() turns any text into all capital letters. "hello world" becomes "HELLO WORLD". Use it the same way as PROPER(): type =UPPER(A1) in an empty column, press Enter, copy the formula down to all rows, then copy and paste the results as values back into your original column.

UPPER() is useful when you need to standardize data for matching or sorting — for instance, if you have customer names entered in mixed case and you want them all uniform for a mail merge or database upload.

Using LOWER() to convert text to all lowercase

LOWER() does the opposite of UPPER(). It converts "HELLO WORLD" or "Hello World" into "hello world". The steps are identical: type =LOWER(A1) in a new column, copy it down, then paste the results as values back over your original text.

You might use LOWER() when preparing data for a system that requires lowercase input, or when you are cleaning up a list where some entries were typed in all caps by mistake.

Replacing your original text with the corrected version

After your formula column shows all the corrected text, you need to move that text back to your original column and delete the helper column. Do not just delete the helper column — you will lose all the corrected text because the original column still contains the formula, not the actual text.

Select all the cells in your helper column that contain the new text. Press Ctrl+C to copy. Click on the first cell of your original column. Right-click and select Paste Special. A dialog box will open. Click the Values radio button (not Formulas, not All). Click OK. The corrected text is now in your original column as actual text, not a formula.

Now you can safely delete the helper column. Your original data is replaced with the case-corrected version.

What to do if you have a mix of cases to fix

If your data is inconsistent — some entries are all caps, some are all lowercase, some are mixed — PROPER() handles all of them. It will convert "JOHN", "john", and "JoHn" all to "John". This is why PROPER() is the most useful of the three formulas for real-world data cleanup.

If you need a different result — for instance, you want to keep some words lowercase like "and" or "the" — Excel's built-in formulas cannot do that. You would need to use a more complex formula or a macro, which is beyond what most users need.

Common mistakes to avoid

The most common mistake is deleting the helper column before pasting the results as values. If you do this, your original column will show #REF! errors because the formulas are looking for data that no longer exists. If this happens, press Ctrl+Z to undo and start the paste-as-values step again.

Another mistake is forgetting to paste as values instead of formulas. If you paste the formula itself back into your original column, you will have two columns of formulas pointing at each other, which creates circular references. Always use Paste Special and choose Values.

A third mistake is using the wrong cell reference. If your text is in column B but you type =PROPER(A1), the formula will pull from the wrong column. Check that the letter in your formula matches the column your text is actually in.

Frequently Asked Questions

Can I change case without using a helper column?

Not with a formula — you need somewhere to put the result before you move it back. However, if you only have a few cells, you can type the corrected text directly. For anything more than a handful of entries, the helper column method is faster and more accurate.

What if my text has apostrophes or special characters?

UPPER(), LOWER(), and PROPER() all handle apostrophes and special characters correctly. "O'Brien" will become "O'brien" with PROPER() (lowercase after the apostrophe), which is technically not standard, but the formulas work without errors.

Do these formulas work in Google Sheets?

Yes. UPPER(), LOWER(), and PROPER() work identically in Google Sheets. The steps are the same: enter the formula in a new column, copy it down, then paste as values back into your original column.

Can I undo this if I change my mind?

Only if you have not closed the file. Press Ctrl+Z when ready after pasting to undo the change. If you have closed and reopened the file, the original case is gone. Always save a backup of your original data before changing case on a large dataset.

What if the formula does not copy down to all my rows?

Make sure you are selecting the cell with the formula, not the result. Click the cell, then look at the formula bar at the top — it should show =PROPER(A1) or similar. If it shows only text, you clicked a result cell instead. Click the correct cell and try again. If double-clicking the corner does not work, manually select from the formula cell to the last row and press Ctrl+D.

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.