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.