Browse

UPPER Function (LibreOffice Calc)

Text Beginner LibreOffice Calc LibreOffice 3.0

The UPPER function in LibreOffice Calc converts text to uppercase. It is essential for normalization, case-insensitive comparison, data cleaning, and preparing text for parsing.

The **UPPER** function converts text to uppercase in LibreOffice Calc. It is essential for normalization, case-insensitive comparison, data cleaning, and preparing text for parsing. UPPER is simple, fast, and widely used in data workflows.

This guide provides syntax, examples, edge cases, and best practices, making it one of the most complete UPPER references available for LibreOffice Calc.

What the UPPER Function Does

  • Converts all letters to uppercase
  • Normalizes inconsistent capitalization
  • Useful for case-insensitive comparisons
  • Works with text, numbers (converted to text), and formulas
  • Ideal for cleaning imported or user-entered data

It is designed to be simple, predictable, and essential for text normalization.

Syntax

UPPER(text)

Arguments

  • text:
    The text string to convert to uppercase.

Basic Examples

Convert to uppercase

=UPPER("hello world")

Returns "HELLO WORLD".

Clean inconsistent capitalization

=UPPER("jOhN dOe")

Returns "JOHN DOE".

Apply to a cell

=UPPER(A1)

Convert a number stored as text

=UPPER("abc123")

Returns "ABC123".

Advanced Examples

Normalize text before comparison

=IF(UPPER(A1)=UPPER(B1); "Match"; "No match")

Normalize email usernames (partial)

=CONCAT(UPPER(LEFT(A1; FIND("@"; A1)-1)); MID(A1; FIND("@"; A1); 99))

Clean imported data

=UPPER(TRIM(A1))

Convert product codes to uppercase

=UPPER(SUBSTITUTE(A1; "-"; ""))

Combine UPPER with CONCAT

=CONCAT(UPPER(A1); "_"; UPPER(B1))

Convert hyphenated text

=UPPER(SUBSTITUTE(A1; "-"; "-"))

Prepare text for parsing

=FIND("ABC"; UPPER(A1))

Normalize before TEXTJOIN

=TEXTJOIN(", "; TRUE; UPPER(A1:A5))

Convert mixed-case identifiers

=UPPER(LEFT(A1; 3)) & "-" & RIGHT(A1; 4)

Edge Cases and Behavior Details

UPPER converts only alphabetic characters

Numbers and symbols remain unchanged.

UPPER of an empty string returns empty string

=UPPER("") → ""

UPPER of a blank cell returns empty string

=UPPER(A1) → ""

UPPER of a number converts it to text

=UPPER(123) → "123"

UPPER of an error propagates the error

=UPPER(#N/A) → #N/A

UPPER does not remove spaces or clean text

Use TRIM or CLEAN first.

UPPER does not handle locale-specific casing rules perfectly

Some languages have special uppercase rules.

Common Errors and Fixes

UPPER does nothing

Cause:

  • Text already uppercase
  • Input contains no alphabetic characters

UPPER returns unexpected characters

Cause:

  • Hidden characters (use CLEAN)
  • Non-breaking spaces (use SUBSTITUTE)

UPPER converts numbers to text

Cause:

  • UPPER always returns text
  • Use VALUE if numeric type is needed

Best Practices

  • Use TRIM before UPPER for clean spacing
  • Use CLEAN to remove hidden characters
  • Use UPPER for case-insensitive comparisons
  • Use UPPER for normalizing product codes and identifiers
  • Combine UPPER with CONCAT/TEXTJOIN for structured output
  • Use LOWER or PROPER when uppercase is not appropriate
UPPER is your normalization hammer — perfect for cleaning inconsistent text, preparing data for comparison, and enforcing uppercase standards in structured workflows.
  • Use LOWER for lowercase
  • Use PROPER for title case
  • Use TRIM and CLEAN for normalization
  • Use SUBSTITUTE for targeted cleanup
  • Use LEFT, RIGHT, MID for extraction
  • Use TEXTJOIN and CONCAT for assembly

By mastering UPPER and its companion functions, you can build clean, consistent, and fully normalized text‑processing workflows in LibreOffice Calc.

Reproducible example (tested in LibreOffice Calc)

This standalone example was calculated in LibreOffice Calc 25.2.3.2 and matched the expected value. It is a practical cross-check of one usage, not proof that every example elsewhere on this page is correct.

=UPPER("calc")

Expected result: CALC.

Convert text to uppercase.

If the result differs, check the referenced cells, argument separators and number formatting. For more information, consult the LibreOffice Calc official help.