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

Excel gives you three functions to convert text to uppercase, lowercase, or proper case (first letter of each word capitalized). You do not need to retype anything — you write a formula in a new column, copy it down, then paste the results back over your original data if you want. The three functions are UPPER(), LOWER(), and PROPER().

Each function works the same way: you point it at a cell, and it outputs the converted text. If your names are in column A and you want them in proper case, you write =PROPER(A1) in column B, press Enter, then copy that formula down to every row that has data. Excel will convert each name as you go.

Key Takeaways

  • Use UPPER() to convert text to all capitals, LOWER() for all lowercase, and PROPER() for title case with the first letter of each word capitalized.
  • Write the formula in an empty column next to your data, then copy it down to match the number of rows you have.
  • After the formula converts your text, copy the results and paste them as values only back into your original column to replace the old text.
  • These functions ignore numbers and special characters — they only change letters.

Using UPPER() to convert text to all capitals

The UPPER() function converts every letter in a cell to a capital letter. Numbers, spaces, and punctuation stay the same.

Click on an empty cell next to your data — if your text is in column A, use column B. Type =UPPER(A1) and press Enter. Excel converts the text in A1 to capitals and shows the result in B1. Click on B1 again, then grab the small square at the bottom right corner of the cell and drag it down to the last row with data. Excel copies the formula down and converts every cell in column A.

Using LOWER() to convert text to all lowercase

The LOWER() function converts every letter to lowercase. It works exactly like UPPER() — the only difference is the output.

Click on an empty cell, type =LOWER(A1), and press Enter. Then drag the corner of that cell down to copy the formula to all your rows. Every letter in column A becomes lowercase, while numbers and punctuation remain unchanged.

Using PROPER() for title case with the first letter capitalized

PROPER() capitalizes the first letter of each word and makes the rest lowercase. This is useful for names and titles that came in as all capitals or all lowercase.

Click on an empty cell, type =PROPER(A1), and press Enter. Drag the corner down to copy the formula. Excel capitalizes the first letter of every word — so "john smith" becomes "John Smith" and "JANE DOE" becomes "Jane Doe".

How to replace your original data with the converted text

After you have converted all your text in the new column, you can copy those results and paste them back into your original column. This replaces the old text with the new case.

Select all the cells in the new column that contain your converted text. Press Ctrl+C (or Cmd+C on Mac) to copy. Click on the first cell in your original column — the one that started with the old text. Right-click and choose "Paste Special". A dialog box opens. Click on "Values" and then click OK. Excel pastes only the text, not the formula, so your original column now holds the converted text. You can then delete the helper column if you no longer need it.

What these functions do and do not change

These functions change only letters. Numbers stay as numbers, spaces stay as spaces, and punctuation marks like hyphens, apostrophes, and commas do not move or change. If you have a cell that reads "123 Main St.", UPPER() will give you "123 MAIN ST." — the numbers and period stay exactly where they are.

PROPER() is the trickiest of the three because it capitalizes the first letter after any space. So "o'brien" becomes "O'brien" (the letter after the apostrophe does not get capitalized because PROPER() only looks for spaces). If you need a different result, you may have to edit those cells by hand after the conversion.

Combining case functions with other formulas

You can nest these functions inside other formulas if you need to do more than one thing at once. For example, =PROPER(TRIM(A1)) removes extra spaces from the beginning and end of a cell, then converts it to proper case. =CONCATENATE(UPPER(A1)," ",LOWER(B1)) takes the first name from column A in all capitals, adds a space, and adds the last name from column B in all lowercase.

These combinations are useful when you are cleaning up data from different sources that used different formatting rules. You can do the cleanup in one step instead of multiple passes.

Frequently Asked Questions

Can I change the case of text without using a helper column?

Not with a formula — formulas always need to go somewhere, so you need at least one empty column. However, some third-party tools and macros can do this. If you use Excel often and hate the extra column, you could learn to write a straightforward macro, but for most people the helper column method is faster and safer.

What if PROPER() capitalizes words I do not want capitalized?

PROPER() capitalizes the first letter after every space, so it treats "mcdonald" as "Mcdonald" instead of "McDonald". If you have many names like this, you will need to fix them by hand after the conversion. For a few problem cases, it is usually faster to edit them directly than to write a more complex formula.

Do these functions work on cells that contain formulas?

Yes. If a cell contains a formula that outputs text, you can wrap it in UPPER(), LOWER(), or PROPER(). For example, if B1 contains =CONCATENATE(A1," ",A2), you can write =UPPER(B1) in another cell to capitalize the result.

Can I undo a case change after I paste the values back?

Yes, as long as you have not closed the file. Press Ctrl+Z (or Cmd+Z on Mac) to undo the paste. If you closed the file, the undo history is gone, so keep a backup of important data before you paste over your original column.

Do these functions work in Google Sheets?

Yes. Google Sheets has the same UPPER(), LOWER(), and PROPER() functions, and they work the same way. The process of copying and pasting values is slightly different — you paste, then use the paste special menu to choose "Values only" — but the formulas themselves are identical.