Documentation/Calc Functions/LOWER
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
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:
- Section 3.13, Default Case Algorithms (view chapter).
- Section 4.2, Case—Normative (view chapter).
- Section 5.18, Case Mappings (view chapter).
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:
ODF standard:
Related (or similar) Excel functions:
LOWER