How to Change Text Case in Microsoft Excel with Lower, Upper & Proper Function –
Author: Syed Arshad Sultan
In this tutorial, we will discuss, How to Change Text Case in Microsoft Excel with lower, Upper, and proper functions. sometimes we need to convert text from small letters into capital letter, Microsoft word provide visual options to convert text case but Microsoft excel does not provide a visual option like Ms. Word.
Microsoft Excel has an excellent assortment of worksheet functions that can handle text. You can access these functions just where you’d expect them: from the Text control in the Function Library group of the Formula tab.
Microsoft Excel provides 3 text functions to convert/ change cases.
- Lower Function
- Upper Function
- Proper Function
Lower Function is Converting all letters in a text string to lowercase. text is the text you want to Convert to lowercase. Characters in the text that are not letters are not changed.
=lower(“Type Text Here”)
return tutorials ocean
if you want to change dynamically change text capital to small, then you can use a cell reference in the formula.
Converts a text string to all uppercase letters.
=UPPER(“Type Text Here”)
return TUTORIALS OCEAN
Coverts a text string to proper case; the first letter in ease word in uppercase, and all other letters to lowercase.
=PROPER(“Type Text Here”)
return Tutorials Ocean
Thank you for reading my tutorial, please share, like, and subscribe to my Youtube Channel “Tutorials Ocean”.