How to Change All Caps Text to Proper Case in Excel

The fastest way: the PROPER function

Excel has a built-in function called PROPER that converts text to proper case — the first letter of each word capitalized, the rest lowercase. If your data is in column A and you want the converted text in column B, type this formula in cell B1:

=PROPER(A1)

Press Enter. The text from A1 will appear in B1 in proper case. Then copy that formula down the entire column by clicking B1, grabbing the small square at the bottom right corner of the cell, and dragging it down as far as your data goes. Excel will explore the formula to every row automatically.

Once the conversion is done, you can copy column B, paste it back into column A as values only (using Paste Special), and delete column B. This replaces your original all-caps text with the proper case version.

Key Takeaways

The PROPER function converts all-caps text to proper case in a single formula: type =PROPER(A1) in an empty column and copy it down.
After the formula converts your text, use Paste Special to paste the results back as values, then delete the formula column.
PROPER capitalizes the first letter of every word and lowercases the rest, so "JOHN SMITH" becomes "John Smith".
If you have multiple columns of all-caps text, repeat the process for each column or nest PROPER inside other formulas.

Step-by-step walkthrough for a full column

Open your spreadsheet and locate the column with all-caps text. Click on the first empty column next to it — if your data is in column A, click on column B. Click on cell B1 (the first row of that empty column).

Type =PROPER(A1) and press Enter. You will see the converted text appear in B1. Now click on B1 again to select it. Look at the bottom right corner of the cell — you will see a small filled square. Click and hold that square, then drag it down to the last row that contains data in column A. Excel will copy the formula down and convert every cell.

Once all your text is converted, click on the column B header to select the entire column. Press Ctrl+C (or Cmd+C on Mac) to copy. Then click on cell A1, right-click, and choose Paste Special. A dialog box will open. Click the radio button next to Values and click OK. This pastes only the text, not the formula, back into column A.

Now you can delete column B since you no longer need it. Your original column A now contains proper case text instead of all caps.

What PROPER does and does not do

PROPER capitalizes the first letter of every word and makes all other letters lowercase. "JOHN SMITH" becomes "John Smith". "PRODUCT NAME" becomes "Product Name". This works well for names, titles, and most regular text.

However, PROPER treats any character that is not a letter as a word boundary. If you have text like "O'BRIEN", PROPER will convert it to "O'brien" — the letter after the apostrophe gets capitalized as if it were the start of a new word. The same happens with hyphens: "SMITH-JONES" becomes "Smith-Jones". If your data contains many contractions or hyphenated words and you need them formatted differently, you may need to clean them up by hand after running PROPER.

Converting multiple columns at once

If you have all-caps text in several columns, you do not have to repeat the process for each one individually. Instead, create your PROPER formulas in empty columns next to all of them at the same time.

For example, if columns A, C, and E contain all-caps text, type =PROPER(A1) in B1, =PROPER(C1) in D1, and =PROPER(E1) in F1. Then select all three formula cells (B1, D1, and F1) by clicking B1, holding Shift, and clicking F1. Now grab the fill handle at the bottom right and drag down to convert all three columns at once. When you are done, copy each formula column and paste it back into its original column as values, then delete the formula columns.

Using Find and Replace as an alternative

Excel also has a Format menu option that can change text case, though it is less straightforward than PROPER. Select the cells containing all-caps text. Go to the Format menu, look for Text (the exact location varies by Excel version), and choose Change Case if available. Select Proper Case from the options.

This method works directly on your original data without needing a helper column, but it is not available in all versions of Excel — particularly older versions or Excel Online. If you do not see a Change Case option in your Format menu, use the PROPER function instead. The PROPER function works the same way in every version of Excel.

Handling special cases and cleanup

After converting text with PROPER, scan your results for anything that looks wrong. Acronyms like "USA" will become "Usa", which may not be what you want. Abbreviations like "DR." (for Doctor) will become "Dr.", which is usually correct but worth checking.

If you have a small number of cells that need manual fixing, click on them and type the correct text. If you have many cells with the same problem — for example, dozens of acronyms that should stay all caps — you can use Find and Replace to fix them in bulk. Press Ctrl+H (or Cmd+H on Mac), type the incorrect version in the Find field and the correct version in the Replace field, and click Replace All.

Frequently Asked Questions

Can I convert the text in place without using a helper column?

Not with PROPER — you need an empty column to hold the formula results, then copy them back. However, some versions of Excel have a Format > Text > Change Case menu option that works directly on selected cells. If your version has it, that is faster. Otherwise, the helper column method takes only a few seconds.

What if PROPER capitalizes words I do not want capitalized?

PROPER capitalizes the first letter of every word, so "THE UNITED STATES" becomes "The United States". If you need different capitalization rules, use Find and Replace after converting to fix specific words. For example, find "The" and replace it with "the" in cells where it should be lowercase.

Will PROPER work on a column with mixed case text?

Yes. PROPER converts any text to proper case regardless of its current case. "john SMITH", "JOHN smith", and "John Smith" all become "John Smith".

Can I undo the conversion if I make a mistake?

Yes, as long as you have not saved the file. Press Ctrl+Z (or Cmd+Z on Mac) to undo. If you have already saved, you will need to re-enter the original all-caps text or restore from a backup.

What happens if I use PROPER on numbers or special characters?

PROPER leaves numbers and special characters unchanged. Only letters are affected. "ACCOUNT #12345" becomes "Account #12345".

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.