LOWER Function in Excel: Syntax, Examples and Free Practice
LOWER is an Excel Text function. Converts text to all lowercase.
LOWER syntax
=LOWER(text)
Arguments
text: The text to work with
When to use LOWER
LOWER is used to clean up and reshape text data pulled from other systems before reporting on it.
Practice LOWER online, free
Open the live Excel-style spreadsheet and try LOWER yourself. No Excel install or sign-up needed to start.
Practice LOWER now →More Text functions
Frequently asked questions
What does the LOWER function do in Excel?
Converts text to all lowercase.
What is the syntax of LOWER in Excel?
The syntax is =LOWER(text). text: The text to work with.
Where can I practice LOWER online for free?
Open the free live spreadsheet on Cellgrids and try LOWER yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Text functions · Excel case studies · Excel tutorials · Excel shortcuts