How to change case to uppercase
To change the case of text into uppercase means to capitalize all lowercase letters in a text string. Simply put, to change them to ALL CAPS.
You can do this in Excel by using the UPPER function. It has the following syntax:
The only argument in this function is the text. It refers to the text that you want to be converted to uppercase. This can be a reference or text string.
It’s time to open your practice workbook and put this function into action 💪
You will see a column named Original Data which contains names, places, and sentences that are written in different text case formats.
You may have encountered this in real life where you have to work with data that do not appear in a format that you want.
Let’s convert text data in the original data column into uppercase using the UPPER function.
- Double-click on cell B2 to put the cell in Edit mode.
- Type the UPPER function:
- The first and only argument in the UPPER function is the text. You can type in the text string or simply click the cell reference of the text you want to convert to uppercase 😊
In our case, click cell A2. Close the formula with a right parenthesis.
The formula should now look like this:
You have successfully changed the text case to all caps 👍
- Fill in the rest of the rows by dragging down the fill handle or double-clicking it.
All caps in no time!
You don’t have to worry about converting text in large data sets into uppercase. The UPPER function is all you need!
But what if you need to capitalize only the first letter of the text, not all the text characters of the whole text string? 🤔
No worries, Excel can help you do that too using the PROPER function!
Capitalize the first letter using the PROPER function
As the name of the function suggests, the PROPER function converts text into proper form or case. It only capitalizes the first letter of each substring of text.
The text could be a single word. It could also be multiple words such as first and last names, cities and states, abbreviations, suffixes, and honorifics/titles.
The PROPER function follows the same syntax and arguments as the UPPER and LOWER functions:
In a new column of our practice workbook, let’s convert the text string to the proper case 😊
- Double-click cell C2.
- Type the PROPER function:
- Click cell A2 as your text. Then close the formula with a right parenthesis.
- Press Enter. Fill in the rest of the rows using the fill handle.
Only the first letter of each of the substrings of the whole text string is capitalized.
As mentioned above, this works best in converting first and last names, cities and states, abbreviations, and more.
You can convert the text in Microsoft Excel into the proper case in no time! 😀