Google Sheets Cheat Sheet

LOWER Google Sheets Function [With Quiz]

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

LOWER Syntax

=LOWER(text)

This function is useful for converting things that are usually lowercase case (like email addresses and website URLs) to a consistent format.

LOWER, in combination with functions like LEFT and RIGHT, can also be used to make part of some text lowercase.

FREE RESOURCE

Google Sheets Cheat Sheet

Learn 12 tips and tactics that will make your sheets more beautiful and user-friendly from today.

Google Sheets Cheat Sheet

By entering your email address you agree to get email updates from me. I'll respect your privacy and you can unsubscribe at any time.

LOWER Function Example

ABC
1TextFormulaOutput
2PACKAGING@DUNDERMIFFLIN.com=LOWER(A2)packaging@dundermifflin.com
3www.DunderMifflin.com=LOWER(A3)www.dundermifflin.com
4WUPHF.com=LOWER(A4)wuphf.com

You can also reference text directly instead of using a cell reference:

=LOWER("PACKAGING@DUNDERMIFFLIN.com")

Will output: packaging@dundermifflin.com

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:

ABC
1TextFormulaOutput
2PACKAGING@DUNDERMIFFLIN.com=ArrayFormula(LOWER(A2:A4))packaging@dundermifflin.com
3www.DunderMifflin.comwww.dundermifflin.com
4WUPHF.comwuphf.com

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:

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:

An array value could not be found.

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.

LOWER Function Exercises
Enter a formula for each question in the formula bar for the spreadsheet below.
1. Single Cell
In cell B2, enter a formula that change the second piece of text in the list into lowercase. Remember to start your formula with '='.
2. Whole Column
In cell C2, enter a formula that changes every item in the list to lowercase using a range reference. Remember, the LOWER function won't do this by itself.
ABC
1TextSingleColumn
2PACKAGING@DUNDERMIFFLIN.com
3www.DunderMifflin.com
4WUPHF.com
Click Here When Complete

FREE RESOURCE

Google Sheets Cheat Sheet

Learn 12 tips and tactics that will make your sheets more beautiful and user-friendly from today.

Google Sheets Cheat Sheet

By entering your email address you agree to get email updates from me. I'll respect your privacy and you can unsubscribe at any time.

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.