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 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