The fastest way to change text case in Excel

Excel does not have a built-in button to convert text case the way some word processors do. Instead, you use a formula called LOWER() to convert uppercase text to lowercase, UPPER() to convert lowercase to uppercase, or PROPER() to capitalize the first letter of each word. The formula goes in a new column, then you copy the results back over your original text if you want to replace it.

The process takes about two minutes once you know the steps. You will create a helper column with the formula, copy it down to match your data, then paste the results as values back into your original column.

Key Takeaways

  • Use the LOWER() formula to convert text to all lowercase, typing =LOWER(A1) in a new column where A1 is the cell you want to convert.
  • Copy the formula down to every row that contains text by selecting the cell and dragging the small square at the bottom-right corner down to the last row.
  • Copy all the converted text, then paste it back into your original column using Paste Special and selecting Values Only to replace the old text.
  • Delete the helper column once you have pasted the results, since the formulas are no longer needed.

Setting up the LOWER formula in a helper column

Open your spreadsheet and locate the column containing the text you want to convert. Let's say your uppercase text is in column A. Click on cell B1 (the column next to your text) and type =LOWER(A1) then press Enter. The text from A1 will appear in B1 in all lowercase letters.

If you want to convert to uppercase instead, type =UPPER(A1). If you want only the first letter of each word capitalized, type =PROPER(A1). The process is identical for all three — only the formula name changes.

Copying the formula down to all your rows

Click back on cell B1 where you entered the formula. You will see a small square in the bottom-right corner of the cell. Click and hold that square, then drag it down to the last row that contains text in column A. As you drag, Excel will copy the formula down and automatically adjust it for each row — B2 will contain =LOWER(A2), B3 will contain =LOWER(A3), and so on.

If you have many rows, you can use a faster method: click B1, then hold Shift and click on the last cell in column B that should contain the formula. Then press Ctrl+D (on Windows) or Command+D (on Mac) to fill down the formula to all selected cells at once.

Replacing your original text with the converted version

Once the formula has been copied to all rows, select all the cells in column B that now contain your converted text. Copy them by pressing Ctrl+C (or Command+C on Mac). Now click on cell A1 (the first cell of your original column) and right-click, then choose Paste Special.

In the Paste Special dialog box, click on Values Only (or just Values depending on your version of Excel), then click OK. This pastes only the text results, not the formulas, back into column A. Your original uppercase text is now replaced with lowercase text.

Cleaning up by deleting the helper column

Column B still contains the formulas you used to do the conversion. Since you no longer need them, right-click on the column B header and select Delete. This removes the entire helper column and leaves you with just your original column A, now containing the converted text.

If you made a mistake and want to undo the whole process, press Ctrl+Z (or Command+Z on Mac) repeatedly to step back through your actions. Excel will restore your original text and the helper column.

Converting text in the middle of a cell

Sometimes you have text that is mixed case and you only want to change part of it. The LOWER(), UPPER(), and PROPER() formulas convert the entire cell contents. If you need more control — for example, converting only the second word in a cell to lowercase — you will need to combine these formulas with other functions like MID(), FIND(), or CONCATENATE(). These combinations are more complex and usually only necessary for very specific formatting tasks.

For most everyday work, the three basic formulas handle what you need. If you find yourself needing to convert only portions of cells regularly, that is often a sign the data should be split into separate columns first — one column per piece of information — which makes future formatting much simpler.

Frequently Asked Questions

What if I have text in multiple columns I want to convert?

Create helper columns next to each one. In column B, type =LOWER(A1). In column C, type =LOWER(B1) if B contains text you want to convert, and so on. Copy each formula down, then paste the results back into the original columns in the same order. Delete the helper columns when finished.

Can I convert text without using a helper column?

Not in standard Excel. Some versions have a Format menu option for text case, but it is not reliable across all versions. The helper column method works the same way in every version of Excel and Google Sheets, so it is the most dependable approach.

Will the PROPER formula capitalize every word correctly?

PROPER capitalizes the first letter after any space or punctuation, which works for most cases. However, it may not handle exceptions like "McDonald" correctly — it might convert it to "Mcdonald". If you have many proper names, review the results and fix exceptions manually.

What happens if I paste the converted text back but forget to use Paste Special?

If you paste normally instead of using Paste Special, you will paste the formulas instead of the text. Column A will then show the formula results, but if you delete column B, column A will show errors. Undo the paste and try again with Paste Special set to Values Only.