Samudranesia.id – Sometimes we need to capitalize letters when working with Excel. For that, knowing how to change lowercase letters to uppercase letters in Excel will really help our work. By having these skills, we can create text data in Excel more quickly and easily.
One of the challenges when creating text data in Excel is changing the case. Because, Microsoft Excel does not have a menu that allows users to do Change Case like the one in Microsoft Word.
Even so, that doesn’t mean you can’t change lowercase to uppercase or vice versa. There is a separate way that you can do regarding this letter changing activity.
4 Ways to Change Lowercase to Uppercase in Excel
There are several ways that you can use if you want to convert lowercase letters to capital letters in Excel. The most commonly used way is to use functions.
1. Using the Letter Function
The letter functions that are often used in Excel are the upper function and the lower function. The upper function is used to convert lowercase letters to uppercase letters. The lower function is used to convert capital letters to lowercase.
a. Upper Function
The upper function will make the letters in Excel change to capitals. To convert to lowercase using the upper function you need to put it in the =UPPER(text) function syntax. The text in the syntax of this function contains text or cell references that will be converted into capitals.
For example, you can write text directly in the syntax of the function like =UPPER(“I want to learn excel”) or you can enter the cell where the text is located. For example by writing =UPPER(B11).
After writing text or cells in the function syntax, you can simply press the Enter key. The result of the upper function will be displayed in a row of words that all use capital letters, for example I WANT TO LEARN EXCEL.
b. Lower Function
The lower function has the opposite use because it will make all capital letters in Excel lowercase. To use the lower function, you need to enter the text to be converted into the =LOWER(text) function syntax.
You can enter the text to be converted directly into the function’s syntax like =LOWER(“I LEARN TO COOK”) or by entering the cell where the text is located. For example by writing =LOWER(C5).
Both the text and the entered cells will result in writing with the same typeface. So after you press the Enter key, the text that will be displayed is I learned to cook.
2. Using the Proper Function
You’re not just changing the text to all caps or all lowercase. However, sometimes it is also necessary to change the capital letters that are at the beginning of words only. For this activity, you can use the proper function.
The proper function will convert the first letter of each word in the text to uppercase and the next letter of the word to lowercase. To use this function you need to enter text into the =PROPER(text) function syntax.
For example, when you want to change the following sentence “I learn to dance in class” with a capital letter in each word. So, just enter the text into the syntax of the =PROPER(“I’m learning dance in class”) function.
In addition to entering text, you can also enter the cell where the text is in the function syntax to change each letter at the beginning of the word to capitalize. For example, by writing =PROPER(B9).
Both methods will produce the same text, namely the presence of a capital letter at the beginning of each word in the sentence. After you press the Enter key, the text generated by the function is I Learn to Dance in Class.
3. Using Flash Fill
Want to know how to convert lowercase to uppercase in Excel without using a function? You can try changing the text by using the flash fill feature in Excel. However, this feature can only be used in Microsoft Excel 2022 or later versions.
This feature is able to fill a range of cells according to the detected pattern and the previously given input. The flash fill feature in this activity will help you detect the pattern of changing lowercase letters to uppercase letters in the text that we create.
To change lowercase letters to capital letters, you can follow these steps.
- Change the text that you have written into all capital letters and move the cursor to the cell next to it to put the changed text in capital letters.
- Press the Ctrl + E keys on the keyboard at the same time.
- Excel will automatically detect the input pattern you provide and apply it to the rest of the cells that you create in the table.
- The texts will automatically be capitalized according to the entries you wrote.
- To change the text directly in the cell, you just need to copy the result and move it to the entry cell.
In using the flash fill feature, people will usually change the top one text or word first. Then just move the cursor in the cell below it and by implementing this feature, the text results in the rest of the cells will follow automatically.
In addition to using the Ctrl + E shortcut, the flash fill feature can be accessed via the Home tab and clicking the dropdown on the Fill menu. Another way is to access this feature via the Data tab on your Excel worksheet. Whichever method is used will produce the same text.
4. Change the Font Type
In Excel you can find fonts that consist of all capital letters. You can change lowercase letters to capital letters by changing the font in the text that is made. The steps are as follows.
- Highlight the row of cells containing the text that you want to change the font for using the mouse cursor.
- Click the Home tab and select the type of font that will be used by clicking the dropdown option next to it so that the available font options can be seen all the way down.
- Choose a font that consists of all capital letters. In the dropdown box you can see how the style of each font is written so it’s easy to find fonts with all capital letters.
- After selecting a certain font, the letters in the text whose cells you highlight will change to all capital letters following the selected font type.
This method is very easy to use because there is no need to use functions. In addition, the appearance of the text becomes more attractive with a font style that each has its own characteristics.
How to change lowercase to uppercase in Excel can be done in several ways, whether using functions or not. You just need to choose the method that suits your work needs.
