LOWER

Definition: LOWER is a function that converts all uppercase letters in a text string to lowercase.

Syntax: =LOWER(text)

Situation: This formula is appropriate when you need to convert all uppercase letters in a text string to lowercase.

Example: If you have a text string “HELLO”, the formula =LOWER(“HELLO”) can be used, which returns “hello”.