The fastest way to convert text in Excel

Excel does not have a built-in button to convert text case, but you can do it in seconds using the UPPER function. Type =UPPER(A1) in any empty cell, replace A1 with the cell containing your text, and press Enter. The cell will show the text in all capitals. If you need to convert many cells at once, copy the formula down the column.

If you want to replace the original text instead of creating a new column, copy the converted cells, then paste them back as values only. This removes the formula and leaves just the uppercase text in place of the lowercase original.

Key Takeaways

  • The UPPER function converts any text to uppercase: type =UPPER(A1) in an empty cell and press Enter.
  • You can explore the formula to multiple cells at once by selecting the first cell and dragging the fill handle down to copy it to other rows.
  • To replace the original lowercase text, copy the uppercase results and paste them back as values using Paste Special.
  • Excel also offers LOWER and PROPER functions if you need to convert text to all lowercase or capitalize only the first letter of each word.

Using the UPPER function for single cells

Start by clicking an empty cell next to or below the text you want to convert. Type the formula =UPPER(, then click the cell containing the lowercase text, then type the closing parenthesis and press Enter. For example, if your text is in cell A1, you would type =UPPER(A1).

The cell will when ready display the text in all capitals. The original cell remains unchanged. You now have two versions of the text — the lowercase original and the uppercase copy.

Converting multiple cells at once

If you have lowercase text in cells A1 through A10, click an empty cell in column B (such as B1) and type =UPPER(A1). Press Enter. The formula converts the text in A1 to uppercase and displays it in B1.

Now click B1 again to select it. Look for the small square in the bottom-right corner of the cell (called the fill handle). Click and drag it down to B10. Excel copies the formula down the entire column, automatically adjusting each row so that B2 contains =UPPER(A2), B3 contains =UPPER(A3), and so on. All your text is now converted in seconds.

Replacing the original text with uppercase versions

After you have converted your text using the UPPER function, you may want to remove the lowercase original and keep only the uppercase version. First, select all the cells in the new column that contain the uppercase text (for example, B1:B10). Right-click and choose Copy, or press Ctrl+C.

Now click the first cell of the original column (A1) and right-click. Choose Paste Special. A dialog box will open. Click the radio button next to Values and click OK. This pastes only the text itself, not the formula, into the original cells. You can now delete the helper column (column B) since your original column now contains the uppercase text.

Other text conversion functions in Excel

Excel includes two other case-conversion functions alongside UPPER. The LOWER function converts text to all lowercase: type =LOWER(A1) to convert uppercase or mixed-case text to all lowercase. The PROPER function capitalizes the first letter of each word and makes the rest lowercase: type =PROPER(A1) to convert "john smith" to "John Smith".

All three functions work the same way. Type the function name, open a parenthesis, click or type the cell reference, close the parenthesis, and press Enter. You can copy any of these formulas down a column to convert many cells at once, then use Paste Special to replace the originals if you want.

Handling special characters and numbers

The UPPER function converts letters to uppercase but leaves numbers, spaces, and punctuation exactly as they are. If your cells contain mixed content like "order #123 - john doe", the UPPER function will convert it to "ORDER #123 - JOHN DOE" without affecting the numbers or symbols.

This makes the UPPER function safe to use on any text, regardless of what else is in the cell. You do not need to clean or prepare your data first.

Frequently Asked Questions

Can I undo the conversion if I make a mistake?

Yes. If you have not yet replaced the original text, straightforward delete the helper column with the formulas. If you have already pasted the uppercase text back over the original, press Ctrl+Z when ready to undo the paste operation and restore the lowercase version.

What if I want to convert only part of a cell?

The UPPER function converts the entire cell contents. If you need to convert only certain words or characters within a cell, you will need to use a more complex formula combining UPPER with MID, LEFT, RIGHT, or CONCATENATE functions. For most cases, converting the whole cell is simpler.

Does the UPPER function work in Google Sheets?

Yes. Google Sheets uses the same UPPER, LOWER, and PROPER functions with identical syntax. Type =UPPER(A1) in a Google Sheet the same way you would in Excel, and it will work exactly the same.

Can I convert text that is already formatted as a formula result?

Yes. If a cell contains text that came from another formula, you can still wrap it in the UPPER function. For example, if A1 contains =CONCATENATE(B1,C1), you can type =UPPER(A1) in another cell and it will convert the result to uppercase.