How to Change Text Case in Microsoft Excel with Lower, Upper & Proper Function – Tutorials Ocean

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.

Excel Function Library

Microsoft Excel provides 3 text functions to convert/ change cases.

  1. Lower Function
  2. Upper Function
  3. 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”.

Contact:

Any Kind Of Help Or Needs So Contact Me:
Facebook Group: [ https://www.facebook.com/Tutorials-Ocean-185506455425271/ ]

Leave a Reply

Your email address will not be published. Required fields are marked *