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.

An example of the LOWER function in Excel

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”.

Another example of the LOWER function in Excel

Interactive GSheet