The fastest way to change case in Excel

Excel does not have a built-in button to flip text between uppercase and lowercase. Instead, you use a formula called UPPER(), LOWER(), or PROPER() depending on which case you want. These formulas take the text from one cell and rewrite it in a new cell in the case you choose.

The process takes three steps: write the formula in an empty column, copy it down for all your rows, then paste the results back as plain text over your original data. It sounds longer than it is—most people finish in under a minute.

Key Takeaways

  • Use =UPPER(A1) to change text to all capitals, =LOWER(A1) for all lowercase, and =PROPER(A1) to capitalize the first letter of each word.
  • Write the formula in an empty column next to your data, then copy it down to match the number of rows you have.
  • Copy the formula results, paste them as values over your original text, then delete the formula column.
  • The three formulas work on text that is already in cells—they do not change how you type new data going forward.

Using UPPER() to convert text to all capitals

Click on an empty cell next to the text you want to change. If your names are in column A, click on a cell in column B. Type =UPPER(A1) and press Enter. The text from A1 will appear in all capitals in your new cell.

Now copy that formula down to every row that has data. Click the cell with your formula, then drag the small square at the bottom-right corner of the cell down to the last row. Or click the cell, copy it (Ctrl+C), select the range where you want it, and paste (Ctrl+V). Excel will automatically adjust the cell reference—A1 becomes A2, A3, and so on.

Once all your text is converted, select all the results in the new column, copy them, then right-click on your original column and choose Paste Special. Click Values and then OK. This replaces your original text with the uppercase version. Delete the formula column when you are done.

Using LOWER() to convert text to all lowercase

The process for lowercase is identical to uppercase—only the formula changes. Click an empty cell and type =LOWER(A1), then press Enter. The text will appear in all lowercase in your new cell.

Copy the formula down to all your rows the same way: drag the corner, or copy and paste it to the range. Then copy the results, use Paste Special > Values to replace your original text, and delete the formula column.

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

If you want the first letter of each word capitalized and the rest lowercase—called "title case"—use =PROPER(A1). This is useful for names, titles, or headings where you want consistent capitalization.

Follow the same three steps: write the formula in an empty column, copy it down to all rows, copy the results, paste them as values over your original data, and delete the formula column.

What to do if your data is in multiple columns

If you have first names in column A and last names in column B, you will need to convert each column separately. Write =UPPER(A1) in column C for first names, copy it down, then write =UPPER(B1) in column D for last names and copy that down too. Convert both columns to values, then delete columns C and D.

Alternatively, if you want to combine the columns after converting, you can use a formula like =UPPER(A1)&" "&UPPER(B1) to put both names in uppercase with a space between them in a single new column. Copy that down, convert to values, and replace your original columns.

Fixing case when formulas do not work as expected

The most common problem is forgetting to convert the formulas to values before deleting the formula column. If you delete the column with =UPPER(A1) before pasting as values, your converted text will turn into error messages because the formula no longer has a cell to reference. If this happens, undo the deletion (Ctrl+Z) and follow the paste-as-values step before deleting.

Another issue is that these formulas only change the case of text that is already in cells. If you type new data into the original column after converting, it will stay in whatever case you type it. The formulas do not automatically update new entries—you would need to copy the formula down again for any new rows.

When to use Find & Replace instead of formulas

If you only need to change a few individual cells, using Find & Replace can be faster than writing a formula. Open Find & Replace (Ctrl+H), type the text you want to find, type the replacement in the case you want, and click Replace All. This works well for specific words but is slower than formulas when you have hundreds of rows.

For large datasets, formulas are always faster. For a handful of cells, either method works—use whichever feels more natural to you.

Frequently Asked Questions

Can I change case without using a formula?

Excel has no menu button for case conversion. Formulas are the standard method. Some third-party add-ins exist, but they cost money and are unnecessary—the built-in formulas are free and take less than a minute to use.

What if I want to undo the case change after I paste as values?

If you have not closed the file, use Ctrl+Z to undo. If you have closed and reopened the file, the original case is gone. Always keep a backup of important data before making bulk changes, or work on a copy of your spreadsheet first.

Do these formulas work on text with numbers or special characters?

Yes. UPPER(), LOWER(), and PROPER() work on any text in a cell, including text mixed with numbers and symbols. Numbers and symbols stay unchanged—only letters are affected.

Can I explore case conversion to a whole column at once without using a separate column?

No—you need a helper column to write the formula, then paste the results back. Excel does not have an in-place case conversion tool. The process is quick enough that the extra column is not a real inconvenience.