LOWER Function (LibreOffice Calc)

• Converts all letters to lowercase
• 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.

LOWER(text)

Arguments

• text:
  The text string to convert to lowercase.

Convert to lowercase

=LOWER("HELLO WORLD")

Returns "hello world".

Clean inconsistent capitalization

=LOWER("jOhN dOe")

Returns "john doe".

Apply to a cell

=LOWER(A1)

Convert a number stored as text

=LOWER("ABC123")

Returns "abc123".

Normalize text before comparison

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

Normalize email usernames (partial)

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

Clean imported data

=LOWER(TRIM(A1))

Convert product codes to lowercase

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

Combine LOWER with CONCAT

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

Prepare text for parsing

=FIND("abc"; LOWER(A1))

Normalize before TEXTJOIN

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

Convert mixed-case identifiers

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

LOWER converts only alphabetic characters

Numbers and symbols remain unchanged.

LOWER of an empty string returns empty string

=LOWER("") → ""

LOWER of a blank cell returns empty string

=LOWER(A1) → ""

LOWER of a number converts it to text

=LOWER(123) → "123"

LOWER of an error propagates the error

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

LOWER does not remove spaces or clean text

Use TRIM or CLEAN first.

LOWER does not handle locale-specific casing rules perfectly

Some languages have special lowercase rules.

• Use TRIM before LOWER for clean spacing
• Use CLEAN to remove hidden characters
• Use LOWER for case-insensitive comparisons
• Use LOWER for normalizing product codes and identifiers
• Combine LOWER with CONCAT/TEXTJOIN for structured output
• Use UPPER or PROPER when lowercase is not appropriate

• Use UPPER for uppercase
• 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 LOWER and its companion functions, you can build clean, consistent, and fully normalized text‑processing workflows in LibreOffice Calc.