Contact
12 programs
Explore the site

PROPER Function (LibreOffice Calc)

Text Beginner LibreOffice Calc Introduction not established

The PROPER function in LibreOffice Calc converts text to title case, capitalizing the first letter of each word and converting the rest to lowercase. It is essential for cleaning names, titles, and inconsistent capitalization.

Verification status: Consult the documentation, examples and any stated test scope below. How formula examples are checked

Availability and version history

  • Introduced: Documented by LibreOffice 26.8.1.1; original introduction not established.
  • Availability: Supported in LibreOffice 26.8.1.1, verified against its function registry. This identifies a supported release, not a final working version.
  • Scope: Desktop Calc, using the English function name. Availability in other spreadsheet applications is separate.
  • Checked: 2026-10-14 — function reference; versioned support. Documentation/source check; not a new native test. Existing example-specific test claims below retain their stated scope.
The **PROPER** function converts text to title case in LibreOffice Calc. It capitalizes the first letter of each word and converts all other letters to lowercase. PROPER is essential for cleaning names, titles, and inconsistent capitalization in imported or user-entered data.

What the PROPER Function Does

  • Capitalizes the first letter of each word
  • Converts all other letters to lowercase
  • Normalizes inconsistent capitalization
  • Works with text, numbers (converted to text), and formulas
  • Useful for names, titles, and labels

It is designed to be simple, predictable, and ideal for text cleanup.

Syntax

PROPER(text)

Arguments

  • text:
    The text string to convert to title case.

Basic Examples

Convert to title case

=PROPER("hello world")

Returns "Hello World".

Clean inconsistent capitalization

=PROPER("jOhN dOE")

Returns "John Doe".

Apply to a cell

=PROPER(A1)

Convert a number stored as text

=PROPER("123abc")

Returns "123Abc".

Advanced Examples

Clean names imported from a database

=PROPER(TRIM(A1))

Clean names with extra spaces

=PROPER(TRIM(SUBSTITUTE(A1; CHAR(160); " ")))

Convert product titles

=PROPER(SUBSTITUTE(A1; "_"; " "))

Combine PROPER with CONCAT

=CONCAT(PROPER(A1); " "; PROPER(B1))

Convert hyphenated names

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

(Then optionally remove spaces around hyphens.)

Convert multi-word titles

=PROPER(LOWER(A1))

Clean and normalize before comparison

=IF(PROPER(TRIM(A1)) = PROPER(TRIM(B1)); "Match"; "No match")

Convert email-like strings (partial)

=PROPER(LEFT(A1; FIND("@"; A1)-1))

(Not for full email normalization.)

Edge Cases and Behavior Details

PROPER capitalizes after:

  • Spaces
  • Tabs
  • Line breaks
  • Most punctuation

PROPER does not preserve:

  • Acronyms (e.g., “NASA” → “Nasa”)
  • Initialisms (e.g., “HTML” → “Html”)
  • Intentional stylization (e.g., “iPhone” → “Iphone”)

PROPER of an empty string returns empty string

=PROPER("") → ""

PROPER of a blank cell returns empty string

=PROPER(A1) → ""

PROPER of a number converts it to text

=PROPER(123) → "123"

PROPER of an error propagates the error

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

PROPER does not remove extra spaces

Use TRIM first.

PROPER does not remove non-breaking spaces

Use SUBSTITUTE(A1; CHAR(160); " “) first.

Common Errors and Fixes

PROPER returns unexpected capitalization

Cause:

  • Acronyms converted to title case
  • Stylized words normalized
  • Hyphenated words treated as separate words

Fix:
Use SUBSTITUTE or manual corrections.

PROPER does not fix spacing

Cause:

  • TRIM not applied
  • Non-breaking spaces present

Fix:
Use TRIM and SUBSTITUTE.

PROPER converts numbers to text

Cause:

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

Best Practices

  • Use TRIM before PROPER for clean spacing
  • Use SUBSTITUTE to normalize non-breaking spaces
  • Use PROPER for names, titles, and labels
  • Avoid PROPER for acronyms or stylized text
  • Combine PROPER with CONCAT/TEXTJOIN for structured output
  • Use LOWER or UPPER when title case is not appropriate
PROPER is your capitalization normalizer — perfect for cleaning names, titles, and inconsistent text into clean, readable title case.
  • Use UPPER for full uppercase
  • Use LOWER for full lowercase
  • 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 PROPER and its companion functions, you can build clean, readable, 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.

=PROPER("hello world")

Expected result: Hello World.

Capitalize the first letters of words.

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