PROPER Function (LibreOffice Calc)
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.
Compatibility
▾| Excel | ✔ |
| Gnumeric | ✔ |
| Google_sheets | ✔ |
| Libreoffice | ✔ |
| Numbers | ✔ |
| Onlyoffice | ✔ |
| Openoffice | ✔ |
| Wps | ✔ |
| Zoho | ✔ |
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.
Related Patterns and Alternatives ▾
- 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.