How to Use LOWER Function

The LOWER function converts all uppercase letters in a text string to lowercase, and keep other characters as they are. For example, "LOWER Function" will be converted to "lower function".

Formula:

=LOWER(text)

Explanations:

The text is required, which is the text string that you need to convert uppercase to lowercase.

Cautions:

All the characters that are not letters will not be changed.

Example: Change all letters in the text string "How to Use LOWER Function" to lowercase

=LOWER(A2)

The result returns "how to use lower function" and all letters in uppercase are converted to the lowercase.

Download: LOWER Function

Leave a Reply