Excel has three built-in functions that change text case without retyping

You can convert text to all capitals, all lowercase, or title case (first letter of each word capitalized) using Excel's UPPER, LOWER, and PROPER functions. These functions work on any cell containing text — names, addresses, product descriptions, anything. The original text stays unchanged; the function creates the new version in a separate cell, which you can then copy back over the original if you want.

The process takes three steps: write the function in an empty cell, copy it down for all the text you need to change, then copy the results and paste them back as values over your original data. Most people finish this in under a minute once they see it done once.

Key Takeaways

  • UPPER converts text to ALL CAPITALS, LOWER converts to all lowercase, and PROPER converts to Title Case With Each Word Capitalized.
  • You write the function in an empty column next to your original text, like =UPPER(A2) if your text is in column A.
  • After the function produces the new text, you copy those cells, then paste them as values back over your original data to replace it permanently.
  • These functions work on entire columns at once — you do not have to change each cell individually.

Using UPPER to convert text to all capitals

Click on an empty cell next to the text you want to change. If your names are in column A starting at row 2, click on cell B2. Type =UPPER(A2) and press Enter. Excel converts the text in A2 to capitals and displays it in B2.

Now copy this formula down for every row that has text. Click on B2 again, then grab the small square at the bottom right corner of the cell and drag it down to the last row with data. Or click B2, hold Shift, and click on the last cell in that column where you want the formula — then press Ctrl+D (Windows) or Cmd+D (Mac) to fill down. Every cell in column B now shows the uppercase version of the text next to it.

To replace your original text with these uppercase versions, select all the cells in column B that have the converted text. Copy them (Ctrl+C or Cmd+C). Click on the first cell in column A where your original text starts. Right-click and choose Paste Special. In the dialog that appears, click Values and then OK. Your original text is now all capitals, and you can delete column B.

Using LOWER to convert text to all lowercase

The process is identical to UPPER, except you type =LOWER(A2) instead. Click an empty cell, type the formula, press Enter, then drag or fill down to copy it to every row with text. The result appears in lowercase in your new column.

Copy the results, then paste them as values over your original text the same way: select the converted cells, copy, click your original column, right-click, choose Paste Special, select Values, and click OK. Your text is now all lowercase.

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

Type =PROPER(A2) in an empty cell next to your text. Press Enter. Excel capitalizes the first letter of each word and makes the rest lowercase. This is useful for names, addresses, and product titles that arrived in all capitals or all lowercase and need to look professional.

Fill the formula down to every row with text, then copy the results and paste them as values over your original data using the same Paste Special method. PROPER is stricter than you might expect — it capitalizes the first letter after any space or punctuation, so "O'Brien" becomes "O'brien" and "McDonald's" becomes "Mcdonald'S". If your data has many names with apostrophes or possessives, check a few results before you commit the change.

Replacing your original text with the converted version

After you have created the converted text in a new column, you need to replace your original data. Selecting and copying the new column, then using Paste Special to paste only the values (not the formulas) is the standard way. If you just copy and paste normally, you paste the formula itself, not the text it created — your new column would disappear if you deleted the original.

Once you have pasted the values over your original text, you can safely delete the helper column with the formulas. Your original column now contains the converted text, and the formulas are gone. If you realize you made a mistake, press Ctrl+Z (or Cmd+Z on Mac) when ready to undo and try again.

Handling mixed case and special characters

UPPER and LOWER work on any text, including numbers and special characters — they only affect letters. Numbers, spaces, punctuation, and symbols pass through unchanged. If you have a cell containing "Product #42-XL", UPPER converts it to "PRODUCT #42-XL" and LOWER converts it to "product #42-xl".

PROPER is more aggressive. It treats any non-letter character as a word boundary, so "email@domain.com" becomes "Email@Domain.Com" — probably not what you want. For email addresses, URLs, or other text with internal punctuation that should not be capitalized, use UPPER or LOWER instead, or manually fix the PROPER results afterward.

Converting text in place without a helper column

If you do not want to use an extra column, you can type the formula directly into your original cells, but you lose the original text. Click on a cell containing text you want to change. In the formula bar at the top, type =UPPER( before the existing text, then add a closing parenthesis ) at the end. Press Enter. The cell now shows the uppercase version, but the original text is gone.

This method is risky because you cannot undo easily if you change your mind. The helper column method is safer — you always have the original text visible while you work, and you can compare before you delete anything. For a single cell or two, the direct method is fine. For a whole column, use the helper column approach.

Frequently Asked Questions

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

No — UPPER, LOWER, and PROPER work on the entire cell contents. If you need to change only part of a cell, you have to use more complex formulas combining UPPER or LOWER with LEFT, RIGHT, or MID functions, or manually edit those cells. For most spreadsheet work, changing the whole cell is what you need.

What if my text is in multiple columns and I want to change all of them?

Create the formula in a helper column for the first column of text, fill it down, then copy the formula across to match however many columns you have. If names are in columns A and B, write =UPPER(A2) in column C, fill down, then copy C2 and paste it into D2. Adjust the formula in D2 to =UPPER(B2) and fill down. Then paste both columns C and D as values back over A and B.

Will these functions work on numbers that look like text?

UPPER, LOWER, and PROPER only affect letters, so numbers are not changed. If you have a cell containing "123ABC", UPPER converts it to "123ABC" with no change to the numbers. If the numbers are stored as actual text (which is rare), they still will not be affected.

Can I undo after I paste the values over my original text?

Yes, when ready. Press Ctrl+Z (Windows) or Cmd+Z (Mac) right away and your original text comes back. Excel's undo history usually goes back many steps, so you have a window to catch mistakes. If you close the file without saving, the undo history is lost, so save only after you have checked that the conversion worked correctly.

What if I want to change case but keep a backup of the original text?

Do not paste the values over your original column. Instead, keep the helper column with the converted text as a new permanent column in your spreadsheet. Delete the formulas by copying and pasting as values, then rename the column header to something clear like "Name (Uppercase)". This way you have both versions if you need to reference the original later.