Transforming Text to Uppercase in Word and Excel

When composing your document and finishing the content, during the editing process in Word and Excel, you may need to convert a piece of text from lowercase to uppercase. Instead of deleting and pressing Caps Lock or holding the Shift key to re-enter the text, you have various quick methods to accomplish this task. Below is a detailed guide on different ways to convert lowercase to uppercase in Word, Excel. Feel free to explore!

Converting Text to Uppercase in Word

Method 1: Direct Conversion in Word with Built-in Features

Step 1: Highlight the text you want to write in uppercase.

Step 2: Choose the Home -> Aa icon -> UPPERCASE tab (or press the Ctrl + Shift + A shortcut) to convert it to uppercase. Here, you can also change the selected text to various styles:

• Sentence case: capitalize the first letter of each sentence.
• lowercase: write all letters in lowercase.
• Capitalize Each Word: capitalize the first letter of each word.
• tGOOGLE cASE: write the first letter of each word in lowercase, with subsequent letters in each word capitalized.

Note: You can also highlight the text you want to convert and press the SHIFT + F3 combination until it appears in uppercase as desired.

You will achieve the following results:

Method 2: Using Unikey software          

Step 1: Highlight the text you want to convert to uppercase and right-click to select Copy.

Step 2: Right-click on the Unikey icon in the system tray -> Tools…[CS+F6] or press Ctrl + Shift + F6 to open the Unikey Toolkit dialog box.

Step 3: Here you customize as follows:

• In the character set section, select Source and Target as Unicode (1).
• In the Options section, choose Convert to uppercase (2).

Then press Convert (3), when a successful message appears, select OK.

Step 4: Reopen the Word document, right-click and select Paste (or press Ctrl + V), and you will have the uppercase text.

Convert lowercase to uppercase in Excel

Use the UPPER function to convert to uppercase, for example:

=UPPER(“Mytour”) the result will be Mytour

For a specific example, suppose you have a customer information table, and you want to convert all content in the Last Name column to uppercase.

Step 1: Add a temporary column to hold the Last Name you want to convert to uppercase.

Step 2: Utilize the function:  =UPPER() to convert text to uppercase.

Additionally, you can employ the function =PROPER() to capitalize the first letter of each word, and the function =LOWER() to convert to lowercase.

In this example, input the formula =UPPER(A2) into the first cell of the temporary column.

Step 3: Position the mouse pointer at the bottom right corner of the cell containing the UPPER function, the cursor will change to a + sign, then click and drag down to the cells below to copy the formula.

As a result, all cells will be converted to uppercase. To convert to a different format, you can follow the same steps.

Hope this article will be helpful to you, wishing you success!