The fastest way to change case in Excel

Excel does not have a built-in button to change text case the way Word does. Instead, you use a formula — usually the UPPER, LOWER, or PROPER function — to convert text in one column into a new column with the case you want. The formula takes seconds to write, and you can apply it to hundreds of cells at once.

If you have a list of names in column A and you want them in title case (first letter of each word capitalized), you would type =PROPER(A1) in cell B1, press Enter, then copy that formula down the column. Excel recalculates the formula for each row automatically.

Key Takeaways

  • UPPER converts all text to capitals, LOWER converts all text to lowercase, and PROPER converts to title case (first letter of each word capitalized).
  • Write the formula in a new column next to your original text, then copy it down to all rows that contain data.
  • After the formula produces the results you want, copy the new column and paste it as values only to replace the original text, then delete the formula column.
  • These three functions work the same way in Excel Online, Excel for Mac, and Excel for Windows.

Using UPPER to convert text to all capitals

The UPPER function takes any text and converts every letter to a capital letter. Numbers and punctuation stay the same. Type the formula as =UPPER(A1) where A1 is the cell containing the text you want to change.

Click on the cell where you typed the formula and press Enter. Excel shows the result in that cell. If you have 50 rows of data, click the cell with the formula, then drag the small square at the bottom-right corner of the cell down to row 50. Excel copies the formula to every row and adjusts the cell reference automatically — row 2 becomes =UPPER(A2), row 3 becomes =UPPER(A3), and so on.

Using LOWER to convert text to all lowercase

The LOWER function converts every letter to lowercase. Type =LOWER(A1) in the cell where you want the result. Press Enter, then copy the formula down to all rows with data the same way you would with UPPER.

This is useful when you have a column of mixed case text — some words capitalized, some not — and you need everything in lowercase for consistency or for a specific format your system requires.

Using PROPER for title case (first letter capitalized)

The PROPER function capitalizes the first letter of each word and makes all other letters lowercase. Type =PROPER(A1) in your new column. Press Enter and copy the formula down to all rows containing data.

PROPER is the most common choice for lists of names, company names, or any text where you want a professional appearance. It handles most cases correctly, though it will capitalize the first letter after an apostrophe — so "o'brien" becomes "O'brien" instead of "O'Brien". If you have many names with apostrophes, you may need to fix those manually after the formula runs.

Replacing your original text with the converted results

After your formula column shows the text in the case you want, you need to replace the original column with these results. If you delete the original column while the formula still references it, the formula breaks and shows an error.

Select the entire column of formula results (the new column with UPPER, LOWER, or PROPER). Right-click and choose Copy. Then click on the first cell of your original column and right-click again. Choose Paste Special. In the dialog that opens, click the Values option and then click OK. This pastes only the text results, not the formula itself, into your original column.

Now you can delete the formula column. Your original column now contains the text in the new case, and there is no formula to break if you move or delete cells later.

Combining case conversion with other text functions

You can nest these functions with other Excel text functions if you need to do more than just change case. For example, =PROPER(TRIM(A1)) removes extra spaces from the beginning and end of text, then converts it to title case in one formula.

Or =UPPER(LEFT(A1,1))&LOWER(RIGHT(A1,LEN(A1)-1)) capitalizes only the first letter and makes everything else lowercase — useful for names where PROPER would capitalize after an apostrophe incorrectly. These combinations take more time to write, but they let you fix multiple problems in one step instead of running formulas one after another.

What to do if the formula shows an error

If a cell shows #NAME? error, you likely misspelled the function name. Check that you typed UPPER, LOWER, or PROPER exactly — Excel is case-insensitive for function names, but it must recognize the word. The most common mistake is typing UPPPER (three P's) or LOWE (missing the R).

If a cell shows #REF! error, the cell you referenced in the formula no longer exists — usually because you deleted a column. Delete the formula column and start over, making sure not to delete the original data column while the formula still points to it.

Frequently Asked Questions

Can I change the case of text without using a formula?

Not directly in Excel. You must use UPPER, LOWER, or PROPER in a helper column, then copy the results back as values. Some third-party add-ins offer a case-change button, but the formula method is built into Excel and works everywhere.

Will changing case affect numbers or special characters in the cell?

No. UPPER, LOWER, and PROPER only change letters. Numbers, punctuation, spaces, and symbols stay exactly as they are. A cell containing "John Smith 123!" becomes "JOHN SMITH 123!" with UPPER.

What if I only want to change the case of part of a cell?

You can combine the case functions with LEFT, RIGHT, or MID to work on only part of the text. For example, =UPPER(LEFT(A1,3))&LOWER(RIGHT(A1,LEN(A1)-3)) makes the first three characters uppercase and the rest lowercase. This requires more complex formulas, but it is possible.

Do I have to delete the formula column after pasting values?

No, but it is cleaner to delete it. If you keep both columns, you have duplicate data and the file size is larger. Delete the formula column once you have pasted the values into your original column.

Can I undo the case change if I make a mistake?

Yes, if you have not saved the file. Press Ctrl+Z (or Cmd+Z on Mac) to undo. If you have already saved, you cannot undo. This is why it is safer to work in a helper column first — you can always delete it and start over without losing your original data.