In this tutorial we will learn text function in excel. You can convert your text into deferments cases such as upper case, lower case and proper case if you use text function which is available in excel.

Text function in excel

 

Text Function Upper Case 

This function converts all characters in a piece of text to upper case. type as shown below in image 

After It you will see something like this all text is converted in capita case means upper case 

Text Function Excel Proper Case 

This function converts the first letter of each word to uppercase, and all subsequent letters.
After apply formula your text convert to proper 

Text Function Lower Case 

This function converts all characters in a piece of text to lower case.

here you can see now text is converted in lower case