Converting Uppercase Letters to Lowercase

In this, article we will learn about LOWER function in Microsoft Excel.

LOWER function converts all letters from uppercase (capital letters) to lowercase in a text string.

image 1

 

Let’s take a look at few examples and understand how to use this function in Excel.

image 2

 

1st Example:-

In this example, we will see how LOWER function works. We have taken all the characters in capital letters.

image 3

 

Follow the steps given below:-

  • Enter the function in cell B8
  • =LOWER(A8), Press Enter

image 4

 

The function has converted all the characters into small letters.

Note: The function takes only single argument which is a text argument, and it can either be a cell reference to the location in the worksheet or supplied directly to the argument. The argument is required for function to perform the action.

 

2nd Example:-

In this example, we have a cell with text in mixed letters. Now what will happen if we use LOWER function?

image 5

 

Follow the steps given below:-

  • Enter the function in cell B9
  • =LOWER(A9), Press Enter

image 6

 

The function has converted all the letters into small case and returns text string as “this is sample text”.
 
3rd Example:-

In this example, we will see how function responds, if the text string is already in lower case.

image 7

 

Follow the steps given below:-

  • Enter the function in cell B10
  • =LOWER(A10), Press Enter

image 8

 

The function would not do nothing anything and return to the original text string because it is already in lower case.
 
4th Example:-

image 9

 

Follow the steps given below:-

  • Enter the function in cell B11
  • =LOWER(A11), Press Enter

image 10

 

It has changed only uppercase letters and converted them to lowercase. However, the numbers and special characters remain unaffected. Thus, we can say LOWER function does not affect numbers or special characters.
 
5th Example:-

In this example, we have taken #N/A error in the argument and we’ll see what function would return to?

image 11

 

Follow the steps given below:-

  • Enter the function in cell B12
  • =LOWER(A12), Press Enter

image 12

 

The function has returned #N/A error which we have taken in the argument. That’s because function would look only for text value, and when it found error value in it, it returned the same error as result.

So, this is how LOWER function can be used in different situations in Excel.

 

image 48

 

Video: How to use LOWER function in Microsoft Excel

Click on the video link for quick reference to the use of LOWER function. Subscribe to our new channel and keep learning with us!

 

If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com

 
 

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube