Excel Text Case Conversion Techniques

Case sensitivity: Case sensitivity is an important fact in any computer program. It requires you to enter characters just the way it was pre-programmed. For example: If the command requires uppercase letter then it won’t work if you enter lowercase letter. This is case sensitivity and it has a great impact on Microsoft excel Too. To learn more about case sensitivity you can visit Wikipedia: en.wikipedia.org/wiki/Case_sensitivity Changing Case in Excel: Microsoft Excel doesn’t have change case button for changing capitalization like Microsoft word, yet changing case in excel is very crucial. To change the case of a text you can use excel functions and in this playlist you will learn all about Excel Case: goo.gl/xiP3tv There are different types of letter cases and these are the mostly used character cases in excel. Let’s learn about them. 1. Title case or proper case 2. Sentence case 3. Uppercase 4. Lowercase Title case or proper case: Title case and proper case are the same. If a sentence is written in a way that the first letter of every word is in capital letter and the rest of the letter is in the small letter that is title case or proper case. The name title case came from the writing style of titles which is as same as proper case. So if first letter of every word is capitalized it is called title case or proper case. Example: This Is A Proper Case Sentence. In the following you will find the way of changing proper case to uppercase and proper case to lowercase in Excel 2010. How to change proper case to lowercase in Microsoft Excel 2010: youtu.be/M3FBKERMGOU How to change proper case to uppercase in Microsoft Excel 2010: youtu.be/Zjc9w-9iy8s Sentence case: Sentence case indicates the character case where only the first letter of a sentence is capital letter and the rest is small letter. The way we write usually is sentence case. Example: This is a sentence case example where only first letter is capital. Let’s check a video on converting any sentence in sentence case in Microsoft Excel 2010. How To Capitalize First Letter Of A Sentence In Excel 2010: youtu.be/LtFC-5lY1CI Uppercase: Uppercase letter indicates every letter of a sentence is in capital letter or in All Caps. This is a commonly used letter case. Example: THIS IS UPPERCASE SENTENSE. Let’s check some video on how to change uppercase to proper case and upper case to lowercase. How to change uppercase letter to lowercase in excel: youtu.be/ikq9x9u_mtE How to change uppercase to proper case or title case in excel: goo.gl/GjkUa7 Lowercase: Lowercase letter indicates everything in small letter. That means you’ll write every letter of a sentence in small letter. This is called lowercase letter. Example: this is a lowercase sentence example. Let’s learn how to change lowercase to uppercase and lowercase to proper case in Microsoft Excel 2010. How to change lowercase letters to uppercase in excel: youtu.be/tlYAMEh1IPI How to change lowercase to proper case or title case in excel: youtu.be/SZ4wBBbGCt8 Now in this playlist you will learn transitions between Proper case, lowercase, uppercase and sentence cases. Bonus Video: How to prevent uppercase entry in excel 2010: youtu.be/2qa1iQgnvGw How to prevent lowercase entry in an excel selection: youtu.be/IHAM2Ag96rg Subscribe to the channel: goo.gl/uL8fqQ ______________________________________________________________ Support the channel: www.patreon.com/excel10tutorial ------------------------------------------------------------------------------------------------------ Connect on Social Media: Facebook: www.facebook.com/excel10tutorial/ Blogger: excel10tutorial.blogspot.com/ Tumblr: excel10tutorial.tumblr.com/ Instagram: www.instagram.com/excel_10_tutorial