Convert text to lower case, UPPER CASE and Proper Case : 3 Ways to Change Case of text in
#MsExcel #ExcelTutorial #UppercasetoLowercase
Have you ever wondered how to convert UPPER CASE to lower case and Proper Case, then this video is for you.
1.In order to convert UPPERCASE to lower case use lower formula. =lower()
2. To convert lower case to UPPER CASE , use =UPPER()
3. From UPPER CASE to Proper Case or from lower case to Proper case , use =proper().
Note :
When you copy the changed case to another column, row or another worksheet , copy the data first, use CTRL + ALT+ V ( Shortcut key for paste special window). It prompts you to paste special window, convert the text to values and you will be able to copy and paste the changed text.
Keep Watching, Keep learning.
~-~~-~~~-~~-~
Please watch: "How to Use Concatenate With Vlookup in Excel "
• How to Use Concatenate With Vlookup i...
~-~~-~~~-~~-~