Jump to content

Documentation/Calc Functions/LOWER

From The Document Foundation Wiki


Function name:

LOWER

Category:

Text

Summary:

Converts uppercase characters in a supplied text string to lowercase.

Syntax:

LOWER(Text)

Returns:

Returns a text string that corresponds to the supplied text string, with uppercase characters converted to lowercase.

Arguments:

Text is a text string (in quotation marks) or a reference to a cell containing a text string, that is the string to be converted to lowercase.

Additional details:

The operation of LOWER depends on locale settings and so it should not be regarded as portable.

In addition to converting uppercase characters in the range [A…Z] to lowercase characters in the range [a…z], LOWER also converts many other characters.


The Unicode Standard contains much information about case conversion. The following sections of the standard are relevant:

The three links above lead to sections within the documentation for Unicode 5.2.0, which is the legacy version of the standard that is referenced in ODF 1.2. The latest version of the Unicode Standard can be found via the Unicode public website.

Examples:

Formula Description Returns
=LOWER("Good MORNING") Here the function converts the uppercase letters to lowercase and returns "good morning". good morning
=LOWER(D1) where cell D1 contains the string "Sun". Here the function converts the uppercase letter to lowercase and returns "sun". sun

Related LibreOffice functions:

PROPER

UPPER

ODF standard:

Section 6.20.14, part 2

Related (or similar) Excel functions:

LOWER