How to change text strings to uppercases in Microsoft Excel?
This article is going to talk about some tips about how to change text strings to all uppercase letters easily in Microsoft Excel 2007/2010.
- Change text strings to uppercase in Excel with UPPER function
- Change text strings to uppercase in Excel with Kutools for Excel
Supposing you need to change text strings in A1:A5 to uppercase letters, see the following screen shots:
Using Microsoft Excel's upper function is easy to change text strings to uppercase letters in one cell.
Enter =UPPER(A1) in Cell C1, and press Enter key. Then the content of "change case" in Cell A1 is copied and changed to "CHANGE CASE" in Cell C1. See screen shot:
Select the Cell C1, and you can copy the formula to other cells by dragging at bottom-right corner and dropping down to other cells.
Kutools for Excel's Change Case tool can help you all text strings or letters to uppercase letters in a range of Microsoft Excel 2007/2010.
Kutools for Excel includes more than 100 handy Excel tools. Free to try with no limitation in 30 days. Get it Now.
Step 1: Select the range in which you will change text strings to uppercase letters.
Step 2: Click the Kutools >> Text Tools >> Change Case…. See screen shot:
Step 3: In Change Case dialog box, check the UPPER CASE option, and click OK button. See screen shot:
Then you will see that all text strings in selection are changed to uppercase letters. See screen shot: