Use the UPPER Function to Convert Text to All Capitals

The fastest way to change lowercase text to uppercase in Excel is the UPPER function. Type =UPPER(cell) in a new column, replace "cell" with the cell containing your lowercase text, and press Enter. Excel converts that text to all capitals when ready.

For example, if cell A1 contains "hello world", typing =UPPER(A1) in cell B1 produces "HELLO WORLD". You can then copy this formula down to convert an entire column of text at once.

Key Takeaways

  • The UPPER function converts any text to uppercase: type =UPPER(A1) where A1 is the cell you want to convert.
  • Copy the formula down to convert multiple cells at once by selecting the formula cell and dragging the fill handle to the last row you need.
  • After converting, copy the uppercase results and paste them as values only to replace the original text, then delete the formula column.
  • The PROPER function capitalizes the first letter of each word, and the LOWER function converts text to all lowercase if you need those instead.
  • Excel's Find & Replace feature cannot change case on its own, so the UPPER function is the standard method.

Copy the Formula Down to Convert Multiple Rows

If you have dozens or hundreds of lowercase entries, you do not need to type the formula for each one. Enter =UPPER(A1) in cell B1, then click on B1 to select it. Move your cursor to the small square in the bottom-right corner of the cell (called the fill handle) until it turns into a plus sign.

Click and drag that plus sign down to the last row containing data. Excel copies the formula to every cell and automatically adjusts the cell reference—so B2 becomes =UPPER(A2), B3 becomes =UPPER(A3), and so on. Release the mouse when you reach the bottom of your data.

Replace the Original Text with the Uppercase Version

After converting your text, you now have two columns: the original lowercase text and the new uppercase text. To replace the original and clean up your spreadsheet, select all the uppercase results in column B. Right-click and choose Copy.

Click on the first cell in column A (the original lowercase text) and right-click. Choose Paste Special. In the dialog box that appears, make sure Values is selected, then click OK. This pastes only the text itself, not the formula. Now you can delete column B entirely, and column A contains your uppercase text.

Use PROPER to Capitalize the First Letter of Each Word

If you need title case instead of all capitals—where only the first letter of each word is uppercase—use the PROPER function instead. Type =PROPER(A1) in a new column, and Excel converts "hello world" to "Hello World".

The PROPER function is useful for names, titles, and headers where all capitals would look wrong. Follow the same copy-and-paste-as-values process to replace your original text once you are satisfied with the result.

Convert Text to Lowercase with the LOWER Function

The LOWER function works the same way as UPPER but does the opposite. Type =LOWER(A1) to convert "HELLO WORLD" to "hello world". This is helpful when you inherit data in all capitals and need to standardize it to lowercase for consistency.

All three functions—UPPER, LOWER, and PROPER—work on the same principle: enter the formula in a new column, copy it down for all rows, then paste the results as values back into the original column if you want to replace the text.

Common Mistakes to Avoid

The most common error is forgetting to paste as values. If you copy the formula results and paste them normally, you paste the formula itself, not the converted text. When you delete the original column, the new column shows errors because the formula references are broken. Always use Paste Special and select Values.

Another mistake is trying to use Find & Replace to change case. Excel's Find & Replace feature cannot change the case of text—it can only find and replace specific words. The UPPER, LOWER, and PROPER functions are the only built-in tools for case conversion.

Frequently Asked Questions

Can I convert text in place without creating a new column?

Not directly with a formula. You must create the formula in a new column, then copy the results and paste them as values back into the original column. This two-step process is how Excel handles case conversion.

What if my data has mixed case, like "HeLLo WoRLd"?

The UPPER function converts all letters to capitals regardless of their starting case, so =UPPER("HeLLo WoRLd") produces "HELLO WORLD". The PROPER function would produce "Hello World".

Does the UPPER function work on numbers or special characters?

The UPPER function ignores numbers and special characters—it only affects letters. A cell containing "abc123!@#" becomes "ABC123!@#" with no change to the numbers or symbols.

Can I undo the conversion after pasting as values?

Yes, as long as you have not saved the file. Press Ctrl+Z (or Cmd+Z on Mac) to undo the paste operation and restore your original text. After you save, the undo history is cleared.

What if I want to convert only part of a cell's text to uppercase?

You would need to combine UPPER with other text functions like MID or CONCATENATE, which is more complex. For most cases, converting the entire cell is simpler. If you need partial conversion frequently, consider whether restructuring your data would help.