Use the PROPER, UPPER, and LOWER Functions to Change Case
Excel has three built-in functions that change the case of text without retyping it: PROPER converts text to title case (first letter of each word capitalized), UPPER converts everything to capitals, and LOWER converts everything to lowercase. These functions work on any cell containing text—names, addresses, product descriptions, anything.
The fastest way is to create the formula in an empty column next to your data, then copy the results back over the original text if you want. This takes about two minutes and works on hundreds of cells at once.
Key Takeaways
- Type =UPPER(A1), =LOWER(A1), or =PROPER(A1) in an empty cell to convert the text in cell A1 to all caps, all lowercase, or title case.
- Copy the formula down to convert an entire column of text at once by selecting the cell with the formula and dragging the small square at the bottom-right corner down to the last row you need.
- After the formulas create the new text, copy the results and paste them as values only over your original data to replace it permanently.
- PROPER capitalizes the first letter of every word, which works well for names but may capitalize words you don't want capitalized, like "mcdonald" becomes "Mcdonald".
Step-by-Step: Convert a Single Cell
Click on an empty cell next to the text you want to change. If your original text is in cell A1, click on cell B1. Type the formula that matches what you need: =UPPER(A1) to make it all capitals, =LOWER(A1) to make it all lowercase, or =PROPER(A1) to capitalize the first letter of each word.
Press Enter. The formula runs when ready and shows the converted text in cell B1. Your original text in A1 stays unchanged. If the result looks right, move to the next step. If you made a typo in the formula, click B1 again, fix the formula in the formula bar at the top, and press Enter.
Step-by-Step: Convert an Entire Column
Click on the cell containing your formula (B1 in the example above). You should see the formula in the formula bar at the top. Position your cursor at the very bottom-right corner of that cell until you see a small black square—this is the fill handle. Click and hold on that square, then drag it down to the last row that contains text you want to convert.
As you drag, Excel shows you how many rows you are filling. Release the mouse button when you reach the last row. The formula copies down automatically, and each row converts the text from the corresponding row in column A. If you have 500 rows of names, this takes about three seconds.
If dragging is difficult on your screen, use this keyboard shortcut instead: click the cell with your formula, hold Shift, and click the last cell in the range you want to fill. Then press Ctrl+D (Windows) or Cmd+D (Mac) to fill down.
Replace Your Original Text with the Converted Version
Once all your text is converted in the new column, you need to copy those results and paste them back into the original column as plain text—not as formulas. If you skip this step and delete the new column, your original data will show error messages because the formulas will have nothing to reference.
Select all the converted text in column B (click the column header B to select the entire column, or click B1 and drag to the last converted cell). Press Ctrl+C (Windows) or Cmd+C (Mac) to copy. Click on cell A1 to select where you want to paste. Right-click and choose Paste Special, or press Ctrl+Shift+V (Windows) or Cmd+Shift+V (Mac). A dialog box opens.
In the Paste Special dialog, make sure only Values is checked—uncheck any other options. Click OK. The converted text pastes into column A as plain text, replacing your original data. You can now delete column B since you no longer need the formulas.
What Each Function Does: Examples
| Original Text | UPPER Result | LOWER Result | PROPER Result |
|---|---|---|---|
| john smith | JOHN SMITH | john smith | John Smith |
| PRODUCT NAME | PRODUCT NAME | product name | Product Name |
| mcdonald's restaurant | MCDONALD'S RESTAURANT | mcdonald's restaurant | Mcdonald'S Restaurant |
| 123 main street | 123 MAIN STREET | 123 main street | 123 Main Street |
UPPER and LOWER are straightforward—they convert everything to one case. PROPER is trickier because it capitalizes the first letter after any space or punctuation, which can create odd results with apostrophes and hyphens. If PROPER creates mistakes you have to fix by hand, it may be faster to use UPPER or LOWER and then manually adjust the few cells that need it.
Common Mistakes to Avoid
The most common error is forgetting to paste as values before deleting the helper column. If you delete column B while column A still contains formulas pointing to it, you will see #REF! errors in column A. If this happens, press Ctrl+Z (Windows) or Cmd+Z (Mac) when ready to undo the deletion, then follow the Paste Special steps above.
Another mistake is using the wrong cell reference in your formula. If your text is in column A but you type =UPPER(B1), the formula will try to convert text from column B, which may be empty or contain different data. Always double-check that the cell reference in your formula points to the column you actually want to convert.
If you have spaces or special characters at the beginning or end of your text, the case functions will not remove them—they only change the case of letters. If you need to clean up extra spaces first, use the TRIM function: =TRIM(A1) removes leading and trailing spaces, and you can combine it with case functions like =UPPER(TRIM(A1)).
Frequently Asked Questions
Can I change case without using a helper column?
Not with the built-in functions—you always need a formula somewhere to do the conversion. However, you can put the formula in the same column if you first move your original text to a temporary location, run the formula in the original column, then delete the temporary column. This is more steps than using a helper column, so most people find the helper column method faster.
What if I only want to change the case of a few cells, not the whole column?
Create the formula in a helper cell next to the first cell you want to convert, copy the formula down only as far as you need, then paste the results back as values. You do not have to convert the entire column—you can select just the range you want to fill.
Does PROPER work correctly with all names and titles?
PROPER capitalizes the first letter after every space, which works well for most English names and titles but creates errors with names like "McDonald" (becomes "Mcdonald") and titles like "iPhone" (becomes "Iphone"). If your data has these cases, you may need to fix them by hand after using PROPER, or use UPPER or LOWER instead and accept that the formatting will not be title case.
Can I undo a case change after I paste the values?
Yes, as long as you have not closed the file. Press Ctrl+Z (Windows) or Cmd+Z (Mac) to undo the paste operation and restore your original text. If you closed the file and reopened it, the undo history is gone and you cannot recover the original case.
What if my text is in a formula, not just plain text?
The case functions work on the result of a formula, not the formula itself. If cell A1 contains =CONCATENATE(B1," ",C1), you can still use =UPPER(A1) to convert the result to uppercase. The case function sees only the text that the formula produces, not the formula code.