LOWER Function Examples – Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on November 9, 2023
Download Example Workbook

Download the example workbook

This tutorial demonstrates how to use the LOWER Function in Excel to convert text to lower case.

Lower-Main-Function

What Is the LOWER Function?

The LOWER Function takes a string of text and converts it to lower case.

How to Use the LOWER Function

Use the Excel LOWER function like this:

=LOWER(“AUTOMATEEXCEL.COM”)

First-Lower

This formula would return the following:

automateexcel.com

Here are a few more examples:

How to Use LOWER

How LOWER Handles Numbers and Special Characters

The Excel LOWER Function has no effect on numbers, punctuation marks, or other special characters.

How LOWER Handles Accented Letters

If you use LOWER on an upper-case accented letter, Excel will return its lower case accented equivalent wherever possible.

Creating Email Addresses Based on Name Data

Imagine you have a list of contacts, and you want to add their email addresses to your spreadsheet. Because email addresses are usually presented in lower case, LOWER is an idea tool to use here.

To create the email addresses, we’d need to concatenate the first name, last name, the “@” email symbol, and the domain name. Concatenate basically just means “join together” – Excel will treat any strings connected by an “&” symbol as one single string.

When we’ve done that, we can just pass the entire concatenated string to LOWER, to get the lower-case version. Like this:

=LOWER(A2&B2&"@"&C2)

Here’s how it works:

Creating email addresses

Note that you can also use Excel’s CONCATENATE function for this. This function concatenates a comma-separated list of strings, like so:

=LOWER(CONCATENATE(A2,B2,"@",C2))

Creating email addresses CONCAT

LOWER in Google Sheets

The LOWER Function works exactly the same in Google Sheets as in Excel:

Lower-G-Function

AI Formula Generator

Try for Free

Excel Practice Worksheet

practice excel worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to List of Excel Functions