How to Change Text Case in Microsoft Excel with Lower, Upper & Proper Function –
[Full Tutorial]
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
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.
Syntax:
=lower(“Type Text Here”)
Example:
=lower(“TUTORIALS OCEAN”)
return tutorials ocean

if you want to change dynamically change text capital to small, then you can use a cell reference in the formula.
=lower(B3)

UPPER Function
Converts a text string to all uppercase letters.
Syntax:
=UPPER(“Type Text Here”)
Example:
=UPPER(“tutorials ocean”)
return TUTORIALS OCEAN
=lower(B3)

Proper Function
Coverts a text string to proper case; the first letter in ease word in uppercase, and all other letters to lowercase.
Syntax:
=PROPER(“Type Text Here”)
Example:
=proper(“tutorials ocean”)
return Tutorials Ocean
=proper(B3)

Thank you for reading my tutorial, please share, like, and subscribe to my Youtube Channel “Tutorials Ocean”.