Excel has three built-in functions to change how text appears without retyping it

Excel does not have a single "change case" button in the toolbar. Instead, you use formulas — UPPER, LOWER, and PROPER — that convert text to all capitals, all lowercase, or title case (first letter of each word capitalized). These formulas create new text in a different cell; they do not modify the original. You then copy the result and paste it back as values if you want to replace the original text.

This matters because case changes are common when you are combining data from different sources. One system might send names in all capitals. Another sends them lowercase. A third uses mixed case. Before you can sort, filter, or match that data reliably, the case needs to be consistent.

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).
  • Type the formula in an empty column next to your data — for example, =UPPER(A2) to convert the text in cell A2 to capitals.
  • Copy the formula down to all rows that contain text, then copy the results and paste them as values into the original column to replace the old text.
  • Delete the helper column once you have pasted the converted text back into your original data.

Using UPPER to convert text to all capitals

The UPPER function takes whatever text is in a cell and converts every letter to a capital letter. Numbers and punctuation stay the same.

Click on an empty cell next to your data — if your names are in column A, click on a cell in column B. Type =UPPER(A2), replacing A2 with the cell that contains the text you want to convert. Press Enter. The cell now shows the text from A2 in all capitals.

To convert all the text in column A, click on the cell with your formula (the one that now shows the capitalized text). Look for the small square in the bottom right corner of the cell. Click and drag that square down to the last row that contains text. Excel copies the formula down and converts every cell in that range.

Using LOWER to convert text to all lowercase

The LOWER function does the opposite of UPPER — it converts every letter to lowercase. Use it the same way: click an empty cell, type =LOWER(A2), and press Enter.

If you have a column of names in mixed case and need them all lowercase for a database or system that requires it, LOWER handles that in seconds. Copy the formula down to all rows, then copy the results and paste them back into the original column as values.

Using PROPER for title case (first letter of each word capitalized)

The PROPER function capitalizes the first letter of each word and makes all other letters lowercase. This is useful when you have names or titles that came in as all capitals or all lowercase and need to look normal.

Type =PROPER(A2) in an empty cell and press Enter. PROPER will capitalize the first letter of "john smith" to show "John Smith", or convert "JOHN SMITH" to "John Smith". It also capitalizes the first letter after an apostrophe, so "o'brien" becomes "O'brien".

How to replace your original text with the converted version

After you have copied your formula down to all rows, you have two columns: the original text and the converted text. To replace the original with the converted version, select all the cells in the converted column that contain your new text. Right-click and choose Copy.

Click on the first cell of your original column (the one you want to replace). Right-click and select Paste Special. A dialog box opens. Click on Values only and then OK. Excel pastes only the text, not the formula. Your original column now contains the converted text.

Delete the helper column (the one with the formula) since you no longer need it. Your data is now in the correct case, and you have only one column instead of two.

Combining case conversion with other text functions

You can nest case functions with other text functions if you need to do more than one thing at once. For example, if you need to remove extra spaces and convert to uppercase, you could type =UPPER(TRIM(A2)). TRIM removes leading and trailing spaces, and UPPER converts the result to capitals.

Common combinations include PROPER with TRIM to clean up title case data, or LOWER with SUBSTITUTE if you need to remove specific characters while converting case. Build the formula step by step and test it on one cell before copying it down to hundreds of rows.

What to do if case conversion breaks your data

Case conversion is usually safe, but it can cause problems if your data contains abbreviations or codes that depend on specific capitalization. For example, if you have product codes like "iPhone12" or "eBay", converting to UPPER gives you "IPHONE12" and "EBAY", which might not match your system's records.

Before you convert a large dataset, test the formula on a few rows and check whether the result still makes sense for your purposes. If case matters for matching or lookup, consider whether you should convert at all, or whether you should convert only for display and keep the original data in a separate column for matching.

Frequently Asked Questions

Can I change case without using a formula?

Not directly in Excel. There is no menu option or button. You must use a formula in a helper column, then copy the results back as values. Some third-party tools or macros can do it, but the formula method is built in and works on any version of Excel.

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

You can combine case functions with text extraction functions like LEFT, RIGHT, or MID. For example, =UPPER(LEFT(A2,1))&LOWER(RIGHT(A2,LEN(A2)-1)) capitalizes only the first letter and lowercases the rest. This is more complex, so test it carefully on one cell first.

Will changing case affect formulas or links in my spreadsheet?

If your formulas reference cells by their content (like a lookup that depends on exact case matching), changing case can break those formulas. If your formulas reference cells by their address (like =A2+B2), case changes do not affect them. Check any lookups or matches before converting.

Can I undo a case conversion after I paste it back?

Yes, as long as you have not saved the file. Press Ctrl+Z (or Cmd+Z on Mac) to undo. If you have saved, you will need to go back to the original data or use the helper column you created before deleting it.