The LOWER function converts a text to lowercase. In this guide, we’re going to show you how to use the this function and also go over some tips and error handling methods.
Supported versions
- All Excel versions
Syntax
LOWER(text)
Arguments
text |
The text you want converted into lowercase. |
Examples
Example 1
=LOWER(“Charizard”)
Example 2
=LOWER(Id&” – “&Name&” – “&Type)
Tips
- Try UPPER function to convert strings into uppercase.
- Try PROPER function to capitalize the first letter of each word in a text.