UPPER Function (LibreOffice Calc)

• 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.

UPPER(text)

Arguments

• text:
  The text string to convert to uppercase.

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".

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)

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.

• 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

• 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.