How to Change Text from Lowercase to Uppercase in Excel

The fastest way to change text case in Excel

Excel does not have a built-in button to flip text between lowercase and uppercase, but you can do it in seconds using the UPPER, LOWER, or PROPER functions. These functions create new text in the case you want, and then you can copy the results back over your original data if you need to.

The method works the same way whether you have 10 cells or 10,000: write a formula in an empty column, copy it down to match your data, then copy the results and paste them as values over the original text. It takes about two minutes total.

Key Takeaways

Use the UPPER function to convert text to all capitals, LOWER for all lowercase, and PROPER to capitalize the first letter of each word.
Write the formula in an empty column next to your data, then copy it down to cover all the rows you need to change.
Copy the formula results, then paste them as values back into your original column to replace the old text.
Delete the helper column once you have pasted the results, so your spreadsheet stays clean.

Using the UPPER function for all capitals

The UPPER function converts any text to uppercase. Click on an empty cell next to the text you want to change. Type =UPPER(A1), replacing A1 with the cell that holds your text. Press Enter.

Excel will show the text in all capitals in that new cell. Now copy this formula down to every row that has text. Click the cell with your formula, then drag the small square at the bottom-right corner of the cell down to the last row you need. Or click the cell, hold Shift, and click the last row you want to fill — then press Ctrl+D (or Cmd+D on Mac) to fill down.

Once the formula is copied to all rows, select all the results, copy them, then click your original column and choose Paste Special. Select Values Only and click OK. This replaces your original lowercase text with the uppercase version. You can now delete the helper column.

Using the LOWER function for all lowercase

The LOWER function does the opposite — it converts text to all lowercase. The steps are identical: click an empty cell, type =LOWER(A1), press Enter, then copy the formula down to all your rows.

This is useful if you have text in mixed case or all capitals and need it uniform and lowercase. Once the formula fills all rows, copy the results, paste them as values over your original column, and delete the helper column.

Using the PROPER function to capitalize each word

The PROPER function capitalizes the first letter of each word and makes the rest lowercase. This is helpful for names, titles, or any text where you want standard capitalization. Click an empty cell and type =PROPER(A1), then press Enter.

Copy the formula down to all rows, copy the results, paste them as values into your original column, and delete the helper column. Note that PROPER capitalizes the first letter after any space or punctuation, so "mcdonald's" becomes "Mcdonald'S" — you may need to fix a few cells by hand if your data has unusual punctuation.

Step-by-step walkthrough for changing a full column

Say you have names in column A from rows 1 to 50, all in lowercase, and you want them in proper case. Click cell B1 (the empty column next to your data). Type =PROPER(A1) and press Enter. Excel shows the first name capitalized correctly in B1.

Now click B1 again. Copy the cell (Ctrl+C or Cmd+C). Click B2, then hold Shift and click B50 to select the range B2:B50. Paste (Ctrl+V or Cmd+V). The formula fills all 50 rows, and column B now shows all your names in proper case.

Select all of column B (B1:B50), copy it, then click A1. Right-click and choose Paste Special, or press Ctrl+Shift+V (Cmd+Shift+V on Mac). A dialog box opens. Click the Values Only option and click OK. Your original column A now holds the proper-case names. Delete column B, and you are done.

Fixing the column width after pasting

Sometimes after you paste the new text, the column width does not adjust and text gets cut off. Double-click the border between the column headers to auto-fit the width. For example, if your text is in column A, double-click the line between the A and B column headers at the top, and Excel will widen column A to fit the longest entry.

If you have many columns to adjust, select all of them, then double-click any border between column headers to auto-fit all selected columns at once.

Changing case without a helper column

If you do not want to use an extra column, you can use Find & Replace with regular expressions, but this method is more complex and only works for specific patterns. For most people, the helper column method is faster and less error-prone. The helper column takes up space for only a few seconds, and you delete it when you are done.

Another option is to use a macro or script if you work in Excel frequently and change case often, but that requires learning VBA code. For a one-time or occasional task, the UPPER, LOWER, or PROPER function is the simplest approach.

Frequently Asked Questions

Can I change case without creating a new column?

Not easily with the built-in functions. The formula has to go somewhere, so you need at least a temporary column. Once you paste the results as values back into your original column, you delete the helper column, so your final spreadsheet looks the same as before.

What if I only want to change a few cells, not the whole column?

The process is the same — just copy the formula down only as far as you need. If you have 50 rows but only want to change rows 1 through 10, copy the formula from B1 down to B10, then paste the results as values into A1:A10. You do not have to fill the entire column.

Does PROPER handle abbreviations correctly?

PROPER capitalizes the first letter after any space or punctuation, so "USA" becomes "Usa" and "mcdonald's" becomes "Mcdonald'S". If your data has many abbreviations or unusual names, you may need to fix a few cells by hand after using PROPER.

Can I undo the change if I make a mistake?

Yes, as long as you have not closed the file. Press Ctrl+Z (or Cmd+Z on Mac) to undo the paste operation and restore your original text. If you have already closed the file, the change is permanent, so always keep a backup before making large changes.

What is the difference between PROPER and UPPER?

UPPER makes all letters capitals. PROPER capitalizes only the first letter of each word and makes the rest lowercase. LOWER makes all letters lowercase. Choose based on the format you need for your data.

This guide is for general information only and is not medical, financial, legal, or other professional advice. For decisions specific to your situation, consult a qualified professional. See our Editorial Policy.