Convert lowercase to uppercase in Word, Excel

When you have finished editing the text and content, in the process of editing Word and Excel, you need to convert a piece of text from lowercase to uppercase. Instead of having to delete and press Caps Lock or hold Shift to re-enter the text, you also have different ways to convert lowercase to uppercase quickly. Below is a detailed guide on how to convert lowercase to uppercase in Word, Excel, please refer.

Convert lowercase to uppercase in Word, Excel Picture 1

Turn lowercase to uppercase in Word

Method 1: Move directly on Word with the available functions

Step 1 : Highlight the text you want to capitalize.

Convert lowercase to uppercase in Word, Excel Picture 2

Step 2 : Select the Home tab -> Aa icon -> U PPERCASE (or you press Ctrl + Shift + A) to change to uppercase. Here you can also convert the selected text into different types:

1. Sentence case : capitalize the first letter of each sentence.
2. lowercase : lowercase all letters.
3. Capitalize Each Word : capitalize the first letter of each word.
4. tGOOGLE cASE : lowercase the first letter of each word, the following letters of the word capitalize.

Convert lowercase to uppercase in Word, Excel Picture 3

Note: You can also highlight the text to capitalize and press SHIFT + F3 until you get the capital letters as you want.

Your results will be:

Convert lowercase to uppercase in Word, Excel Picture 4

Method 2: Use the Unikey software          

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

Convert lowercase to uppercase in Word, Excel Picture 5

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

Convert lowercase to uppercase in Word, Excel Picture 6

Step 3 : Here you customize as follows:

1. In the charset, choose Source and Destination as Unicode (1).
2. In the Selection section , select To uppercase (2).

Then click Transcode (3), a successful message appears, select OK .

Convert lowercase to uppercase in Word, Excel Picture 7

Step 4 : Open Word document again, right-click and select Paste ( Ctrl + V combination ), you will get uppercase text.

Convert lowercase to uppercase in Word, Excel Picture 8

Convert lowercase to uppercase in Excel

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

= UPPER ('TipsMake.vn') the result will be THUTHUATPHANMEM.VN

Convert lowercase to uppercase in Word, Excel Picture 9

For example, you have the customer information table, you want to convert all the content in the Last Name box to uppercase.

Step 1: Add a temporary column to contain the First Name and the Name you want to convert to uppercase.

Convert lowercase to uppercase in Word, Excel Picture 10

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

Also you can use the function = PROPER () to capitalize the first letter of the word, function = LOWER () to convert to lowercase)

In this example, you enter the function = UPPER (A2) in the first cell in the temporary column.

Convert lowercase to uppercase in Word, Excel Picture 11

Step 3 : Place the cursor in the lower right corner of the cell containing the UPPER function , a cursor appears in the + sign and you press and hold the mouse button to drag down the lower cells to copy the formula.

Convert lowercase to uppercase in Word, Excel Picture 12

Your results will be all cells are converted to uppercase, to convert to another style you do the same.

Convert lowercase to uppercase in Word, Excel Picture 13

Hope this article will help you, wish you success!