The LOWER function in Excel converts all uppercase letters in a text string to lowercase. It is useful when you need to standardize text data.

Syntax:

LOWER(text)

• text: The text string you want to convert to lowercase. This can be a direct text value or a cell reference.

Example:
If cell A1 contains the text “HELLO WORLD”, the formula =LOWER(A1) will return “hello world”.

Steps to Use:

1. Select the cell where you want the result to appear.
2. Type =LOWER( and then select the cell containing the text or type the text directly.
3. Close the parentheses and press Enter.

Notes:

• The LOWER function does not affect numbers or special characters.
• If the text is already in lowercase, the function will return the same text.