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.

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

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

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

4. Type a close bracket sign

5. Press Enter
6. Done!

## Exercise

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

### 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!

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:

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