How to Quickly and Easily Change Case in Excel 2013
What is you want to convert text from uppercase to lowercase, or from lowercase to uppercase, or from whatever to proper case to make it more readable? Imagine the text if so long or read it from another sheet or even from another file! How can you change the case of text in Microsoft Excel?
Use the UPPER function in Microsoft Excel 2013
Converts text to uppercase. Text can be a reference or text string.
Use the LOWER function in Microsoft Excel 2013
Converts text to lowercase. That is crystal clear that LOWER function does not change characters in text that are not letters. Text can be a reference or text string.
Use the PROPER function in Microsoft Excel 2013
Converts all other letters to lowercase except first letter in a text string and any other letters in text that follow any character other than a letter. These characters would be capitalized. Microsoft Excel PROPER function is very cool and practical function.
Also read Excel Formulas: 10 Formulas That Helped Me Keep My Job