LOWER

Converts the letters of a given string to lowercase. To convert text to uppercase please refer to UPPER.

Syntax

=LOWER(Text)

Arguments

Name

Description

Text

A string to convert to lowercase

Return Value

Given text in lowercase.

Example

Function

Result

Comment

=LOWER(“HeLLo!”)

hello!

only affects letters in uppercase

=LOWER(A1)

hello world

assumes cell A1 contains text “Hello WORLD”