Convert text to uppercase, lowercase, or proper case in Excel

Excel does not have a built-in button to change the case of text the way some word processors do. Instead, you use formulas—short commands that transform your text automatically. The three most common are UPPER() to make all letters capital, LOWER() to make all letters small, and PROPER() to capitalize the first letter of each word.

Each formula works the same way: you type the formula name, put the cell you want to change in parentheses, and press Enter. Excel then shows you the result in a new cell. You can copy that result back over your original text, or keep it in a separate column. The process takes about two minutes once you know the steps.

Key Takeaways

  • Use UPPER() to change text to all capitals, LOWER() for all lowercase, and PROPER() to capitalize the first letter of each word.
  • Type the formula in a new cell next to your original text, then press Enter to see the result.
  • Copy the formula down to explore it to multiple rows at once by dragging the small square at the bottom right of the cell.
  • Once the formulas produce the text you want, copy the results and paste them as values over your original text to replace it permanently.
  • Excel formulas work the same way in all versions, including Excel Online, Google Sheets, and LibreOffice Calc.

Using UPPER() to convert text to all capitals

Click on an empty cell next to the text you want to change. Type =UPPER(A1), but replace A1 with the cell that holds your text. If your text is in cell B3, type =UPPER(B3). Press Enter.

Excel shows the result in the cell where you typed the formula. The original text stays unchanged. If you want to change the formula to work on the cell below, click the cell with the formula, then drag the small square at the bottom right corner down as far as you need. Excel copies the formula to each row and adjusts the cell reference automatically—so the second row becomes =UPPER(A2), the third becomes =UPPER(A3), and so on.

Using LOWER() to convert text to all lowercase

The process for LOWER() is identical to UPPER(). Click an empty cell, type =LOWER(A1) (replacing A1 with your actual cell), and press Enter. The result appears in that cell with all letters converted to lowercase.

Drag the formula down to explore it to multiple rows. When you are done, you will have a column of lowercase text next to your original text. This is useful when you have mixed case entries and need them all uniform for sorting or matching.

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

PROPER() capitalizes the first letter of every word and makes the rest lowercase. Type =PROPER(A1) in an empty cell and press Enter. This is the most common choice when you have names or titles that need consistent formatting.

One thing to watch: PROPER() treats any character that is not a letter as a word boundary. So if you have text like "mcdonald's", it becomes "Mcdonald'S" with a capital S after the apostrophe. If you need to fix these cases by hand afterward, do that before you copy the results back to your original column.

Copy the results back to replace your original text

Once your formulas show the text you want, select all the cells with the formula results. Copy them (Ctrl+C on Windows, Cmd+C on Mac). Then click on the first cell of your original text, right-click, and choose Paste Special. A dialog box opens. Click the Values option and then OK.

This pastes only the text, not the formula, so your original column now holds the new case version. You can then delete the helper column with the formulas. This step is important if you plan to send the file to someone else or use it in another program—formulas only work in spreadsheets, but plain text works everywhere.

explore case change to multiple columns at once

If you have several columns of text that all need the same case change, create your formulas in the first column, then copy them across to the right. Click the cell with your formula, copy it, then select the range of cells where you want it to appear and paste. Excel adjusts the column reference in each formula automatically.

For example, if you have names in column A and addresses in column B, and you want both in proper case, type =PROPER(A1) in cell C1 and =PROPER(B1) in cell D1. Then select both C1 and D1, copy them, and paste down as far as your data goes. Both columns will convert at the same time.

Common mistakes and how to avoid them

The most common mistake is typing the formula in the same cell as your original text. This creates a circular reference error because the formula tries to use itself as input. Always use an empty cell next to your data.

Another mistake is forgetting to paste as values before deleting the helper column. If you delete the column with the formulas, the original column shows an error because the formulas no longer exist. Always copy and paste as values first, then delete.

If your text has extra spaces at the beginning or end, the case formulas will not remove them. Use TRIM() to clean those up first: type =TRIM(A1) in a helper column, then use UPPER, LOWER, or PROPER on the TRIM results. You can also combine them: =UPPER(TRIM(A1)) does both at once.

Frequently Asked Questions

Can I change case without creating a helper column?

Not directly in the cell itself, but you can use Find and Replace with regular expressions in some spreadsheet programs. In Excel, the formula method is the standard approach. In Google Sheets, you can use the same formulas and they work identically.

What if I only want to change case for part of the text?

You will need to use more complex formulas that combine UPPER, LOWER, or PROPER with functions like LEFT, RIGHT, MID, and CONCATENATE. For most cases, it is faster to do these edits by hand or use Find and Replace to target specific text patterns.

Do these formulas work in Google Sheets?

Yes. UPPER(), LOWER(), and PROPER() work exactly the same way in Google Sheets, Excel Online, LibreOffice Calc, and most other spreadsheet programs. The steps are identical.

What happens if I explore PROPER() to text that is already in proper case?

Nothing changes. PROPER() is safe to run on text that is already formatted correctly. It will not break anything or create errors.

Can I undo a case change after I paste values?

Yes, use Ctrl+Z (Windows) or Cmd+Z (Mac) when ready after pasting. If you have already closed the file, the undo history is gone. This is why it is a good idea to save a backup copy before making large changes to your data.