In the previous article, we discuss how to change Case in Word. But this article, we will explain how to Change Case in Excel.
For your information, in this article, we use Microsoft Excel from Office 356.
Different from Microsoft Word, to change sentence case, we can do easily by using the Font Options or Sentence Case Button.
In Microsoft Excel, to change from one Case to another Case need to use a function. The subsequent section will explain how to change a mixed Case to lowercase, uppercase, and proper case.
To do this, you need to create a 4 x 6 table in excel, as shown in the figure below.
The first column will fill by names with mixed case. The second until the fourth column will show the names with lowercase, UPPERCASE, and Proper Case, consecutively.
The example of names:
- LiAm BuRn
- NoAh WaTsOn
- WiLlIaM wHiTaKeR
- aLeXaNdEr WiLeY
- mIcHaEl HoLlOwAy
Change Mixed Case to lowercase
The “LOWER” function is required to change case to lowercase. The “LOWER” function takes one argument, which is a text.
In our example, the text that we want to change to the lowercase locates in column A2, A3, … A6. So all you need to do is fill the function argument with the column name as follows:
=LOWER(A2)
Change Mixed Case to UPPERCASE
The “UPPER” function is required to change the case to uppercase. The “UPPER” function takes one argument, which is a text.
=UPPER(A2)
Change Mixed Case to Proper Case
A PROPER function will change every first character of a word to UPPERCASE.
The “PROPER” function is required to change the case to a proper case. The “PROPER” function takes one argument, which is a text.
=PROPER(A2)