LOWER Function in Excel: Explained

In this article, you will learn how to use the LOWER formula in Excel.

What can you do with the LOWER formula in Excel?

The LOWER function in Excel is used to convert a text string to all lowercase letters.

When do you use the LOWER function in Excel?

The LOWER formula can be a useful tool for comparing & cleaning data, and normalizing text in Excel. Some common uses can be as below:

1. Compare data: If you need to compare text strings in Excel, you may want to convert them all to lowercase first to ensure that capitalization does not affect the results.
2. Data cleaning: The LOWER function can also be used to clean up data by removing duplicate values. For example, if you have a column of email addresses with mixed case, you can use the LOWER function to convert them all to lowercase and then use the Remove Duplicates feature to remove any duplicates.
3. Normalize data: The LOWER function can be used to convert all text in a column to lowercase, which can help you normalize data and ensure consistency.

How to use the LOWER function in Excel

1. Select the cell where you want to display the lowercase text.
2. Type the following formula into the cell: =LOWER(
3. Input a text string that you want to convert manually or refer to a cell containing the text 
4. The cell should now display the lowercase version of the input string

‍

Syntax: 

=LOWER(text)

The picture below shows how the LOWER formula converts the original letters into all lowercase letters.

‍ 

Analyze your live financial data in a snap in Google Sheets

Are you learning this formula to visualize financial data, build a financial model, or conduct financial analysis? In that case, LiveFlow may help you automate manual workflows, update numbers in real-time, and save time. You can access various financial templates on our website, from the simple Income Statement to Multi-Currency Consolidated Financial Statement. Are you interested in this product but are an Excel user? That’s not a problem at all. You can connect Google Sheets to Excel quickly.

To learn more about LiveFlow, book a demo.

‍ 

You can learn about other Excel and Google Sheets formulas and tips that are not mentioned here on this page: LiveFlow‘s How to Guides