Making the characters uppercase and lowercase
By using UPPER () function, you convert all the text in a cell to uppercase.
By using LOWER () function, you convert all the text in a cell to lowercase.
Moreover, by using PROPER () function, you convert the first characters of words in a cell to uppercase.
At the last three functions, you control three cell index by using nested IF ( ). According to the result, you convert the letters in other cells to uppercase or to lowercase by using UPPER (), LOWER () and PROPER () functions.
Related Tutorials
.png)
, ISTEXT(), ISNUMBER() and ISBLANK() functions.png)
Using IF(), ISTEXT(), ISNUMBER() and ISBLANK() functions.
Using the MIN(), MAX(), COUNT() and AVERAGE() functions on a list
Latest
-
Understanding How HYPERLINK Works In Excel
Excel has a built in function to create hyperlinks &...
-
Understanding how MS Excel Query Works
“Query” in MS Excel has same meaning as ...
-
An Introduction To Excel Power Map
Our today’s post is about “Power Map&rdq...
-
Using Pivot Charts For Displaying Data
Conventional charts are mostly used for displaying r...
-
Using “Calculated Items” For Analyzing A Pivot Table
In our last post, we explored how to use calculated ...
