Text Case change functions in Excel.
LOWER Function
This function converts all uppercase letters in a text string to lowercase.
Usage: =lower(text/cell)
Eg:
Cell A1 contains text "THIS is my WeEBSITE", to convert this text on B1 type
=lower(A1)
and press enter.
The text will convert to "this is my website".
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhNXU3Tg_98m4oS6U6PC1WtEbSbpvGnEPzLpVNo1pQWaKvu4iY7UyBckVArDEk7ADl1-xb0TZvuxSwJTAgpmugym1moyjaa7rhiKXfe3eW9zC4e4CgrwE_d8YpopHgFbERVABRq88rDs8k/s400/Lower.jpg)
UPPER Function
UPPER function converts all lowercase letters in a text string to uppercase.
Usage: =upper(text/cell)
Eg:
Cell A1 contains text "This is my website", to convert this text on B1 type
=upper(A1)
and press enter.
The text will convert to "This is my website"
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOyguV2k9ddz9x9X0FvhJUscPLhNunM5eX4qohLIrcmyshJpebbLfSXP2xjLNxcU_TN97ITpDLE42w7ZANT61jZwx-OzqQsYhueEEeXazEff7UyhOGisWJF5FYYSgvIUyVnVV7PVh8nBE/s400/upper.jpg)
PROPER Function
This function converts first letter of all words on a text string into Upper case/capital and a other letters to lower case.
Usage: =proper(text/cell)
Eg:Cell A1 contains text "This is my website", to convert this text on B1 type
=proper(A1)
The text will convert to "This Is My Website"
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgv_CeuYhbFOBVUJi0GJdDw0h6HQL-bVLoAhT5PeFSuvQQm4hCpcC0x_ERk5qoltinxlBe8kw-ST9udGvQXWkha9_psaH4kajThC_HaSisw-sdWLndZFsm5k5muH-aGiYx-J2R09LUZ3sA/s400/proper.jpg)
No comments:
Post a Comment