Microsoft Excel provides set of Text Functions to alter the given text to lowercase, uppercase and capitalize of each word. In this Article, we will discuss the set of functions to be used to convert the text to lower, upper and capitalize.
All these functions takes text as an argument. We can give text directly as an argument or cell reference or another formula which returns the text value.
You can pass numeric values also to these functions, but there will be NO effect in the result, as numeric values do not have any lower and upper variations.
LOWER
function
LOWER
function is used to covert all characters in the given text to lowercase letters.
Formula | Result |
=LOWER(“Apple”) | apple |
=LOWER(123) | 123 |
PROPER
function
This function is used to capitalize the first character of each word in the given text. And it converts all other characters to lowercase letters.
Formula | Result |
=PROPER(“MICROSOFT EXCEL”) | Microsoft Excel |
=PROPER(“code steps”) | Code Steps |
=PROPER(123) | 123 |
UPPER
function
This function will capitalize entire text. That means, it converts all lowercase characters to uppercase characters in the given text.
Formula | Result |
=UPPER(“Microsoft Excel 2013”) | MICROSOFT EXCEL 2013 |
=UPPER(123) | 123 |
We will discuss more topics in my Upcoming Articles.
🙂 Sahida