Browse

LOWER Function (LibreOffice Calc)

Text Beginner LibreOffice Calc LibreOffice 3.0

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

The **LOWER** function converts text to lowercase in LibreOffice Calc. It is essential for normalization, case-insensitive comparison, data cleaning, and preparing text for parsing. LOWER 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 LOWER references available for LibreOffice Calc.

What the LOWER Function Does

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

Syntax

LOWER(text)

Arguments

  • text:
    The text string to convert to lowercase.

Basic Examples

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

Advanced Examples

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)

Edge Cases and Behavior Details

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.

Common Errors and Fixes

LOWER does nothing

Cause:

  • Text already lowercase
  • Input contains no alphabetic characters

LOWER returns unexpected characters

Cause:

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

LOWER converts numbers to text

Cause:

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

Best Practices

  • 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
LOWER is your normalization baseline — perfect for enforcing consistent lowercase text, preparing data for comparison, and cleaning inconsistent input.
  • 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.

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.

=LOWER("HELLO")

Expected result: hello.

Convert text to lowercase.

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