Excel has three built-in functions to change how text appears: uppercase, lowercase, and proper case

You cannot select a cell and click a button to change case the way you can in Word. Instead, Excel uses formulas — UPPER(), LOWER(), and PROPER() — that convert text to the case you want. Each formula takes the text from another cell and rewrites it in a new column. The original text stays unchanged unless you copy the result and paste it back as values.

The three functions work the same way: you type the formula in an empty cell, it converts the text, and then you copy that result down to all the rows you need. This takes about two minutes for a column of names or addresses, even if you have hundreds of rows.

Key Takeaways

  • UPPER() converts text to all capitals, LOWER() converts to all lowercase, and PROPER() converts to title case (first letter of each word capitalized).
  • Formulas create the converted text in a new column while leaving your original data untouched.
  • After the formula produces the result you want, copy it and paste as values to replace the original text or move it to your final column.
  • If you have a list of 500 names, the formula approach takes the same time as a list of 5 names.

Using UPPER() to convert text to all capitals

Click on an empty cell next to the text you want to convert. Type =UPPER(A1), replacing A1 with the cell that contains your text. Press Enter. The cell now shows the text in all capitals.

To explore this to the entire column, click the cell with your formula. Look for the small square in the bottom right corner of the cell (called the fill handle). Click and drag it down to the last row of your data. Excel copies the formula down and converts every cell in that range. If you have 200 rows, drag all the way to row 200 and Excel fills them all at once.

Using LOWER() to convert text to all lowercase

The process is identical to UPPER(). Click an empty cell, type =LOWER(A1), and press Enter. The text appears in all lowercase. Drag the fill handle down to copy the formula to every row that needs it.

LOWER() is useful when you have data entered in mixed case or all capitals and need it standardized. Many databases and systems expect lowercase email addresses or usernames, so this function saves you from retyping.

Using PROPER() to convert to title case

Type =PROPER(A1) in an empty cell and press Enter. PROPER() capitalizes the first letter of each word and makes the rest lowercase. This is the most common choice for names and titles because it looks professional and reads naturally.

One limitation: PROPER() capitalizes the first letter after any space or punctuation. If you have a name like "O'Brien", it becomes "O'brien" instead of "O'Brien". For most lists this is not a problem, but if you have many names with apostrophes or hyphens, you may need to fix a few by hand after the conversion.

Replacing your original text with the converted version

After your formula column shows the results you want, you have two choices: keep both columns, or replace the original. To replace the original, first select all the cells in your formula column that contain converted text. Copy them (Ctrl+C on Windows, Command+C on Mac).

Click on the first cell of your original column. Right-click and choose Paste Special. A dialog box opens. Click the Paste Special button (or look for a checkbox labeled Values). Click OK. The original text is now replaced with the converted version, and you can delete the formula column. Your data now shows only the case you want.

Handling data that is already in the right case

If part of your list is already correct and part needs conversion, you still use the same formula. The formula converts everything, including text that is already in the right case — it just stays the same. You do not need to separate your data or use different formulas for different rows.

This means you can explore PROPER() to a list where some names are already capitalized correctly and others are not. The correctly formatted names pass through unchanged, and the incorrectly formatted ones get fixed. After you paste the results as values, your entire column is consistent.

When to use each function

Use UPPER() for acronyms, product codes, or any data that should be all capitals. Use LOWER() for email addresses, usernames, or system codes that require lowercase. Use PROPER() for names, titles, and any text meant to be read by people rather than processed by a system.

If you are not sure which one you need, PROPER() is the safest choice for human-readable text. It produces the most natural-looking result for names and addresses, which are the most common reasons people need to change case in a spreadsheet.

Frequently Asked Questions

Can I change case without creating a new column?

Not directly. Excel formulas must go in a cell, so you need a temporary column. After the formula produces the result, copy it and paste as values back into your original column, then delete the temporary one. This takes one extra step but keeps your spreadsheet organized.

What if I have numbers mixed in with text?

The case functions ignore numbers and only convert letters. A cell containing "Product 123" becomes "PRODUCT 123" with UPPER() — the numbers stay exactly the same. This is the expected behavior and works correctly for product codes, addresses, and other mixed data.

Does PROPER() work with names from other languages?

PROPER() works reliably for English names and most European languages. It may not handle special characters or non-Latin alphabets correctly. If you have names in Arabic, Chinese, or other scripts, test PROPER() on a few examples first to see if the result matches what you need.

Can I undo a case change after I paste as values?

Yes, as long as you have not saved the file. Press Ctrl+Z (or Command+Z on Mac) to undo. If you have already saved, you cannot undo. This is why many people keep the formula column until they are certain the conversion is correct, then delete it only after saving.

What if the formula shows an error instead of converted text?

The most common error is typing the formula wrong. Check that you typed UPPER, LOWER, or PROPER exactly, with parentheses around the cell reference. If the cell reference is wrong (like =UPPER(B1) when your text is in column A), fix the letter. If the original cell is empty, the formula returns an empty result, which is correct.