Documentation/Calc Functions/UPPER
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
Function name:
UPPER
Category:
Text
Summary:
Converts lowercase characters in a supplied text string to uppercase.
Syntax:
UPPER(Text)
Returns:
Returns a text string that corresponds to the supplied text string, with lowercase characters converted to uppercase.
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 uppercase.
Additional details:
The operation of UPPER depends on locale settings and so it should not be regarded as portable.
In addition to converting lowercase characters in the range [a…z] to uppercase characters in the range [A…Z], UPPER 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 |
|---|---|---|
| =UPPER("Good Morning") | Here the function converts the lowercase letters to uppercase and returns "GOOD MORNING". | GOOD MORNING |
| =UPPER(D1) where cell D1 contains the string "Sun". | Here the function converts the lowercase letters to uppercase and returns "SUN". | SUN |
Related LibreOffice functions:
ODF standard:
Related (or similar) Excel functions:
UPPER