How to Use the LOWER Formula in Excel: Functions, Examples, and Writing Steps - Compute Expert

How to Use the LOWER Formula in Excel: Functions, Examples, and Writing Steps


Home >> Excel Tutorials from Compute Expert >> Excel Formulas List >> How to Use the LOWER Formula in Excel: Functions, Examples, and Writing Steps





In this tutorial, you will learn how to use the LOWER formula in excel completely.

When working with text in excel, we sometimes need to change the case of the text letters. LOWER is one of the excel formulas you can use to do that change process easily, besides UPPER and PROPER.

Want to know more about the formula usabilities and how to use it optimally in excel? Read this tutorial until its last part!

Disclaimer: This post may contain affiliate links from which we earn commission from qualifying purchases/actions at no additional cost for you. Learn more







What is the LOWER Formula in Excel?

LOWER is an excel formula that can help you to change all the letters case in your text into lower case.



LOWER Function in Excel

You can use LOWER to lower the case in all the letters in your text.



LOWER Result

The LOWER result is a text with all its letters in their lower case form.



Excel Version from Which We Can Start Using LOWER

You can start using LOWER since excel 2003.



The Way to Write It and Its Input

Here is the general writing form of LOWER in excel.

= LOWER ( text )


When using LOWER, you just need to input the text which letters you want to convert to lower case letters. That is the only input that LOWER needs to run its function.



Example of Its Usage and Result

Here is the implementation example of LOWER in excel.

How to Use the LOWER Formula in Excel: Functions, Examples, and Writing Steps - Screenshot of the LOWER Implementation Example

As you can see here, we just need to input the text we want to process when we use LOWER. LOWER will immediately return to us the text with all its letters already in their lower case form!



If you input a number (or any other kind of data besides text) into LOWER, it won’t do anything into its content. However, it will change its data type to text.



Writing Steps

After we have discussed the LOWER writing form, input, and implementation example, now let’s discuss its writing steps. These steps should be quite easy to follow as LOWER only needs one input in its writing.

  1. Type an equal sign ( = ) in the cell where you want to put the LOWER result

    How to Use the LOWER Formula in Excel: Functions, Examples, and Writing Steps - Screenshot of Step 1

  2. Type LOWER (can be with large and small letters) and an open bracket sign after =

    How to Use the LOWER Formula in Excel: Functions, Examples, and Writing Steps - Screenshot of Step 2

  3. Input the text which letters you want to convert into their lower case form

    How to Use the LOWER Formula in Excel: Functions, Examples, and Writing Steps - Screenshot of Step 3

  4. Type a close bracket sign

    How to Use the LOWER Formula in Excel: Functions, Examples, and Writing Steps - Screenshot of Step 4

  5. Press Enter
  6. Done!

    How to Use the LOWER Formula in Excel: Functions, Examples, and Writing Steps - Screenshot of Step 6






Exercise

After you learned how to use LOWER in excel, now let’s deepen your understanding by doing this exercise!

Download the exercise file and do all of the instructions. Download the answer key file if you have done them and want to check your answers. Or probably if you are confused about how to do the instructions!

Link to the exercise file:
Download here

Instructions

Do the following three instructions by putting the answers in the gray-colored cells in the appropriate row! Use the LOWER formula to do the instructions!
  1. Convert the letters from the name on the left to their lower case form!
  2. Convert the letters from the product code on the left to their lower case form!
  3. Write your name with capital letters as a LOWER input to try converting those letters into their lower case form!

Link to the answer key file:
Download here


Additional Note

If you input date or time data to LOWER, it will convert the data to its serial number form.



Related tutorials you should learn from:



Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!





Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!




Follow our tutorial content also on


Hand-Picked CE Tutorials

Excel Calculation

How to Sum in Excel

Subtraction in Excel

Multiplication in Excel

Division Excel Calculation

Average Excel Calculation



Excel Formula

VLOOKUP Excel Formula

Excel IF Function

SUM Formula in Excel

COUNTIF Formula in Excel

COUNT Function in Excel



Excel Tips and Trick

How to Print in Excel

Convert Number to Text Excel

Excel Worksheet Definition

Excel Range Definition

How to Add Columns in Excel



Excel Consultation

Contact Us

Privacy Policy

Affiliate Disclosure

Terms & Condition



© 2021 Compute Expert