Excel has built-in functions to convert text case without retyping
You can change text from all capitals to lowercase, title case, or sentence case using Excel's UPPER, LOWER, and PROPER functions. These functions take the text you already have and convert it to a different case in a new cell or column. You do not need to retype anything — Excel does the conversion for you.
The three main functions work the same way: you write a formula that points to the cell containing the text you want to change, and Excel outputs the converted version. Once you have the converted text, you can copy it and paste it back over the original if you want to replace what you started with.
Key Takeaways
- Use =UPPER(A1) to convert text to ALL CAPITALS, =LOWER(A1) for all lowercase, and =PROPER(A1) for Title Case.
- Type the formula in a new cell next to or below your original text, then press Enter to see the result.
- Copy the converted text, then use Paste Special > Values to replace your original text without the formula.
- These functions work on text in any cell, whether it came from typing, importing data, or copying from another source.
Using UPPER to convert text to all capitals
The UPPER function takes any text and converts every letter to a capital letter. Numbers, spaces, and punctuation stay the same. To use it, click on an empty cell and type =UPPER(, then click on the cell that contains the text you want to convert, then type ) and press Enter.
For example, if the text "hello world" is in cell A1, you would click on cell B1, type =UPPER(A1), and press Enter. Cell B1 will now show "HELLO WORLD". You can copy this formula down to convert multiple cells at once — click on B1, then drag the small square at the bottom right corner of the cell down as far as you need.
Using LOWER to convert text to all lowercase
The LOWER function does the opposite of UPPER: it converts every letter to lowercase. Numbers, spaces, and punctuation are not affected. The steps are the same as UPPER — click on an empty cell, type =LOWER(, click the cell with your text, type ), and press Enter.
If you have "HELLO WORLD" in cell A1 and you type =LOWER(A1) in cell B1, the result will be "hello world". Like UPPER, you can copy this formula down to convert a whole column of text at once.
Using PROPER to convert text to title case
The PROPER function capitalizes the first letter of each word and makes all other letters lowercase. This is useful when you have text that is all capitals or all lowercase and you want it to look like a title or a name. The formula works the same way: click an empty cell, type =PROPER(, click your text cell, type ), and press Enter.
If cell A1 contains "john smith" or "JOHN SMITH", typing =PROPER(A1) in cell B1 will show "John Smith". PROPER is often used to clean up imported data where names or addresses came in the wrong case.
Replacing your original text with the converted version
After you have used one of these functions to convert your text, you have two columns — the original and the converted version. If you want to keep only the converted text and remove the original, you need to copy the converted cells and paste them back as values (not formulas).
Click on the cell or column with your converted text. Press Ctrl+C (or Cmd+C on Mac) to copy. Then click on the original text cell, right-click, and choose "Paste Special". In the window that opens, click on "Values" and then click OK. The original text will now be replaced with the converted text, and the formula will be gone. You can then delete the helper column if you created one.
Converting text in place without a helper column
If you want to avoid creating a second column, you can use Find & Replace with regular expressions, but this method is more complex and only works for specific patterns. For most people, using a helper column and then pasting values back is faster and less error-prone.
Another option is to use a macro or script if you work with case conversion often, but that requires learning Excel's macro language. For one-time or occasional conversions, the UPPER, LOWER, and PROPER functions are the most straightforward approach.
What these functions do and do not change
The case conversion functions only affect letters. Numbers stay as numbers, spaces stay as spaces, and punctuation marks stay exactly where they are. If you have a cell with "123 Main Street" or "email@example.com", the numbers and symbols will not change — only the letters will be converted.
These functions also do not remove extra spaces, fix typos, or change the order of words. They only change the case of the letters that are already there. If you need to clean up data in other ways — removing spaces, fixing spelling, or reorganizing text — you will need different functions or manual editing.
Frequently Asked Questions
Can I use these functions on a whole column at once?
Yes. Type the formula in the first cell of your helper column, then click on that cell and drag the small square at the bottom right corner down to the last row you need. Excel will copy the formula to every cell and adjust the cell reference automatically so each row converts its own text.
What if I want to undo the conversion and get my original text back?
If you have not yet saved the file, press Ctrl+Z (or Cmd+Z on Mac) to undo. If you have saved, you will need to retype or re-import the original text. This is why it is a good idea to keep a backup or use a helper column until you are sure you want to replace the original.
Do these functions work with text from other languages?
UPPER and LOWER work with most languages that have uppercase and lowercase letters, including accented characters in European languages. PROPER may not work correctly with all languages — test it first on a small sample before converting a large dataset.
Can I combine these functions with other formulas?
Yes. You can nest these functions inside other formulas. For example, =PROPER(TRIM(A1)) will remove extra spaces and convert to title case in one step. TRIM removes leading and trailing spaces, which is often useful when cleaning imported data.