LOWER Function - Excel
Overview
The LOWER function in Excel is a useful tool for converting all the uppercase letters in a text string to lowercase. This function provides a way to standardize the case of text, making it consistent and easy for comparisons when using lookup and reference functions.
Example:
=LOWER("Elephant")
Syntax:
=LOWER(text)
text
: This is the text string or cell reference containing the text you want to convert to lowercase.
Example
In this example, the LOWER function takes the word “HIKing” and switches all the uppercase letters to lowercase, giving us a final output of “hiking”.