LOWER Google Sheets Function [With Quiz]

Kieran Dixon Updated:  August 24, 2021

In Google Sheets the LOWER function outputs the provided text with all lowercase characters.

LOWER Syntax

• text = the "text" or a cell reference to the text you want to convert to lowercase characters.

FREE RESOURCE

Google Sheets Cheat Sheet

12 exclusive tips to make user-friendly sheets from today:

Get The Cheat Sheet ➜

You'll get updates from me with an easy-to-find "unsubscribe" link.

LOWER Function Example

Using The LOWER Function On A Whole Column

By combining the LOWER function and the ArrayFormula function you can force LOWER to accept more than one argument.

This means you can make multiple cells lowercase, an entire column or row, or even a table with only one formula.

Here's an example using the same data as above:

All of the text is converted to lowercase characters using a single formula.

LOWER Errors

The LOWER function is very stable, handling the following without error:

• Blank cells,
• Numbers (returning them as text), and
• Boolean data (returning them as lowercase text)

If you input a range (e.g. A2:A4) without using ArrayFormula it will output one piece of lowercase text if the range crosses the same row or column as the formula's cell.

Otherwise, it will throw a #VALUE! error:

LOWER Function Quiz

Here's a quick summary of how to use the quiz spreadsheet:

1. Select the required cell while the formula bar is empty
2. Type your answer in the formula bar
3. You can click on the spreadsheet to add cell/range references

Complete all questions to solidify your understanding of the LOWER function.

FREE RESOURCE

Google Sheets Cheat Sheet

12 exclusive tips to make user-friendly sheets from today:

Get The Cheat Sheet ➜

You'll get updates from me with an easy-to-find "unsubscribe" link.

Kieran Dixon started using spreadsheets in 2010. He leveled-up his skills working for banks and running his own business. Now he makes Google Sheets and Apps Script more approachable for anyone looking to streamline their business and life.

You might like:

How To Split Cells In Google Sheets

Need to split data? Click here to learn how to split text to columns horizontally, vertically, multiple delimiters, and fixed widths.

MINA Google Sheets Function [With Quiz]

The MINA function in Google Sheets finds the minimum! Text or numbers... doesn't matter - MINA finds the smallest / most negative.

UPPER Google Sheets Function [With Quiz]

The UPPER function in Google Sheets makes every character in a cell, column, or row uppercase. Learn how to capitalize every letter here.