Excel has three built-in functions to change letter case without retyping

You can convert text between uppercase, lowercase, and proper case (first letter of each word capitalized) using the UPPER, LOWER, and PROPER functions. These functions work on any cell containing text — a name, a product list, an address — and produce the result in a new cell. You do not need to retype anything or use Find and Replace.

The process takes two steps: write a formula in an empty column using one of the three functions, then copy the results back into your original column if you want to replace the old text. Most people keep the converted text in a helper column instead, so they have both versions if they need them later.

Key Takeaways

  • The UPPER function converts all letters to capitals, LOWER converts all to lowercase, and PROPER capitalizes the first letter of each word.
  • Write the formula in an empty column next to your text, then press Enter to see the result when ready.
  • Copy the formula down to explore it to every row in your list by selecting the cell and dragging the fill handle to the bottom.
  • If you want to replace your original text, copy the results, paste them as values only, then delete the old column.

Using the UPPER function to make all letters capital

The UPPER function converts every letter in a cell to a capital letter. Type =UPPER(A1) in an empty cell next to your text, replacing A1 with the cell address of the text you want to change. Press Enter, and Excel shows the result when ready.

If your list runs down column A from row 1 to row 50, click the cell where you typed the formula, then drag the small square at the bottom-right corner of that 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. All your text is now in capitals in the new column.

Using the LOWER function to make all letters lowercase

The LOWER function does the opposite: it converts every letter to lowercase. Type =LOWER(A1) in an empty cell, press Enter, then drag the formula down to every row that contains text. This is useful when you have text in mixed case or all capitals and need it uniform and lowercase — common when cleaning up data from different sources.

The mechanics are identical to UPPER. The only difference is the function name and the output: all letters become small letters, and numbers and punctuation stay unchanged.

Using the PROPER function to capitalize the first letter of each word

The PROPER function capitalizes the first letter of each word and makes all other letters lowercase. Type =PROPER(A1) in an empty cell, press Enter, then drag down to explore it to your whole list. This is the most common choice for names, titles, and product names where you want consistent formatting.

PROPER treats spaces, hyphens, and apostrophes as word breaks, so "JOHN SMITH" becomes "John Smith", "mcdonald's" becomes "Mcdonald'S" (which is not always correct for surnames, but it is consistent), and "new-york" becomes "New-York". If you need perfect formatting for names with special rules, you may need to fix a few cells by hand after using PROPER.

How to replace your original text with the converted version

If you want to keep only the new case and delete the old column, you must convert the formulas to plain text first. Select all the cells in your new column that contain the formula results — the entire column if you converted your whole list. Copy them with Ctrl+C (or Cmd+C on Mac).

Right-click on the original column (the one with the text you want to replace) and choose Paste Special. A dialog box opens. Click the Values option to paste only the text, not the formula. Click OK. Now your original column contains the converted text as plain values, not formulas. You can delete the helper column with the formulas.

If you make a mistake during this step, press Ctrl+Z when ready to undo and try again. Once you delete the helper column, you cannot recover the original text unless you undo before closing the file.

Converting case in a single cell without a helper column

If you only need to change the case of one or two cells, you can type the formula directly into the cell itself. Click the cell containing the text, type =UPPER(A1) (or LOWER or PROPER), and press Enter. Excel replaces the original text with the result.

This method is faster for small jobs but loses your original text. For anything larger than a handful of cells, use a helper column so you can see both versions and undo if needed.

What happens with numbers, punctuation, and special characters

All three functions leave numbers, punctuation, spaces, and special characters exactly as they are. UPPER, LOWER, and PROPER only affect letters. If you have a cell containing "Product #123-A", UPPER converts it to "PRODUCT #123-A" — the numbers, hash, and hyphen do not change.

This makes these functions safe to use on mixed data like addresses, product codes, or phone numbers. You can convert the text portion without worrying about breaking the numbers or formatting.

Frequently Asked Questions

Can I use these functions on a column that is already formatted as text?

Yes. The UPPER, LOWER, and PROPER functions work on any text, regardless of how the cell is formatted. If the text displays in the cell, the function can convert it. The result appears in your new column as plain text.

What if I want to undo after I paste values over my original column?

Press Ctrl+Z (or Cmd+Z on Mac) when ready to undo the paste. This restores your original text. If you have already closed the file, the undo history is gone and you cannot recover the original text. Always keep a backup or use a helper column until you are certain you want to replace the original.

Do these functions work on cells with formulas inside them?

No. If a cell contains a formula that produces text, UPPER, LOWER, and PROPER convert the result of that formula, not the formula itself. For example, if A1 contains =CONCATENATE("hello", "world"), then =UPPER(A1) produces "HELLOWORLD". The original formula in A1 stays unchanged.

Can I change case for only part of a cell, like just the first word?

Not with a single function. UPPER, LOWER, and PROPER work on the entire cell content. To change case for part of a cell, you would need to combine these functions with text functions like MID or FIND, which is more complex. For most situations, converting the whole cell is simpler.

What is the difference between PROPER and just capitalizing manually?

PROPER applies the same rule to every cell when ready, so it is much faster than clicking each cell and editing by hand. It also ensures consistency — every word gets the same treatment. Manual editing is only faster if you have fewer than five cells to change.