=PROPER(text)

There is one argument: no second argument, no optional count, and no documented default when text is omitted. For a literal, use "Sample Text"; for a cell use A2. Do not type the placeholder word text in a real cell formula. The argument order and spelling come from the official PROPER entry, checked 2026-10-11.

The current English ONLYOFFICE Spreadsheet Editor function catalogue includes this function. Its individual official function reference is unversioned. This proves documentation coverage, not that every past Docs server release, Desktop Editors build or mobile application implements identical behaviour. First supported release: not established by the reviewed documentation. This guide is scoped to the documented English-language Spreadsheet Editor and is subject to a real desktop/web test before publication; mobile parity is unverified. See the Docs changelog and Desktop Editors changelog when researching your installed version.

For entry, type a leading =, a function name and parentheses. The English function insertion instructions show comma-separated arguments when a function needs more than one. These functions have one required argument; commas become relevant in nested examples, such as IF(...). In File → Advanced Settings, ONLYOFFICE supports selecting a Formula Language and regional number formatting; a localized function name may differ. The regional settings documentation does not establish a universal argument delimiter for every locale, so use the local Function Arguments tooltip instead of assuming English syntax always copies unchanged.

Paste or type the following literal text into A1:A8 of a new, blank worksheet. Ordinary letters, digits, and hyphens are ASCII. ␠ represents one ordinary space to type; do not put the ␠ glyph itself in the sheet.

1. Open a blank workbook in ONLYOFFICE Spreadsheet Editor. Use a worksheet with column A empty.
2. Type the listed examples into A1:A8. Set input cells to Text before entering IDs or strings that your locale might parse as dates or numbers. Keep all formulas in B2:B8, not in the original data cells.
3. Select B2, enter the shown formula, press Enter, and compare the result with the expected output. Copy a formula downward only after checking the references change as intended.
4. To inspect a surprising result, use the formula bar or Formula → Show Formulas. Original values in A remain unchanged.

All expected outputs are independently checked on simple ASCII input strings. They are not screenshots or observed results from ONLYOFFICE.

Enter =PROPER(A2) in B2. Expected: Maple Ridge. Use =PROPER(A3) in B3; expected: Jane Doe. Use =PROPER(A5), =PROPER(A6), and =PROPER(A7) for the other space-separated words: North Campus, Research Team, East Region respectively. These five expected outputs involve letters and ordinary spaces only, with independent checks.

A4 deliberately contains invoice-204b. Its output under PROPER is not asserted here: the ONLYOFFICE one-paragraph function description does not spell out exactly how punctuation and embedded digits define word boundaries. That is a valuable native test, not a safe cross-software assumption.

Direct string example: =PROPER("nORTH officE") is expected to show North Office.

Type ␠␠EAST OFFICE␠␠ into A8, where each ␠ means an ordinary space you type. Put in B8:

=PROPER(TRIM(A8))

Expected B8: East Office from documented edge-space trimming and simple-word capitalization. Keep A8 for audit purposes, and use the normalized helper column only after confirming native behaviour. If a manager’s department is intentionally written IT, PROPER may make it look like It; manually protect acronyms rather than forcing this function over them.

• Company names and people’s names: Words such as McDonald, iPhone, USA, and initials may need deliberate casing rules. A mechanical title-case function cannot certify identity spelling. Review corrected names manually.
• Punctuation: Only simple space-separated inputs are asserted here. Apostrophes (O'Brien), hyphens, digits, slashes and non-Latin scripts require a product/version native test; don’t copy Excel’s punctuation rules into an ONLYOFFICE claim.
• Unwanted capitalization: For codes that must remain uppercase use UPPER; for lowercased display use LOWER. Both have their own documented rules.
• Unexpected error or literal formula: Check the =, the matching parentheses, a real cell reference and quotation marks around literal text. Re-enter using the Insert Function wizard to rule out editing in text format. No specific error output was observed in a live app.
• Spaces do not disappear: PROPER controls case, not spacing. Pair with separately documented TRIM for leading/trailing ordinary spaces; nonbreaking-space handling is unverified.

Microsoft Excel documents PROPER(text) and explicitly explains capitalization after any non-letter character. The ONLYOFFICE PROPER reference states the broader word-level purpose but does not explicitly document the same punctuation rule. The English name and required argument are aligned; punctuation specifics and Unicode mappings require independent native comparison rather than assumed identity.

• Existing ONLYOFFICE FILTER guide

• Existing ONLYOFFICE COUNTIF guide: count categories after standardizing source values in a helper column; check that workbook’s matching logic separately.

• Official ONLYOFFICE PROPER guide — source of this page’s purpose and exact syntax.

• ONLYOFFICE Spreadsheet Editor — function documentation
• current English ONLYOFFICE Spreadsheet Editor function catalogue
• Docs changelog
• Desktop Editors changelog
• regional settings documentation
• UPPER
• LOWER

Verification status: Official documentation checked; example outcomes were independently reasoned or arithmetically checked where applicable. Not executed in ONLYOFFICE Spreadsheet Editor.

• No genuine ONLYOFFICE Spreadsheet Editor screenshots are included; this guide does not use mock application images.