UPPER Function in ONLYOFFICE Spreadsheet Editor: Formula and Examples

=UPPER(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 UPPER 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.

In B2, enter =UPPER(A2); expected MAPLE RIDGE. In B3, use =UPPER(A3); expected JANE DOE, demonstrating that text already uppercase remains uppercase. In B4, use =UPPER(A4); expected INVOICE-204B, preserving the hyphen and digits while capitalizing the final letter. Copy =UPPER(A5) through =UPPER(A7) for the other rows and compare them to the table.

Text-literal variant: =UPPER("north campus") is expected to produce NORTH CAMPUS. Quotation marks surround literal text; bare words are not valid text literals. This is a fresh cell formula, not a replacement for A5.

Set A8 to ␠␠ca-on-1047␠␠ (type two ordinary spaces at each edge; do not type the ␠ symbols). In B8 enter:

=UPPER(TRIM(A8))

Expected B8: CA-ON-1047, if TRIM removes the ordinary leading/trailing spaces described in ONLYOFFICE TRIM help, then UPPER converts the letters. The first operation does not alter A8. This is an independently checked ASCII chain; native nested-function evaluation is still untested.

A second real-world use is generating a standardized prefix. For A4 (invoice-204b), =UPPER(LEFT(A4,7)) is expected to give INVOICE. The LEFT argument behaviour is documented separately here.

• Case seems unchanged: Check whether the source was already uppercase (JANE DOE) or the result cell is displaying a cached value. Recalculate from the Formula tab if the workbook has not updated.
• Formula displayed literally: Check for a leading equals sign and whether the result cell is formatted as text before entry. Re-enter the formula through the Function wizard if needed.
• Error instead of converted text: Verify that the function name is UPPER, brackets are balanced, the reference exists, and any string literal has straight double quotes. Do not infer a specific error code without testing the installed version.
• Whitespace remains: UPPER changes case, not spacing. Apply a separately verified cleanup function and retain original values for auditing.
• Accented letters, Turkish I/i, Unicode special cases, emojis and mixed scripts: The official short description does not specify every locale-sensitive mapping. This batch tested ASCII only and leaves those outcomes for platform-specific native tests. Do not promise character-count invariance for all Unicode inputs.

Microsoft Excel also documents UPPER(text); Google Sheets also documents UPPER(text). The same basic English formula name and text argument are documented in those products. This is syntax-level compatibility, not a guarantee of identical Unicode or locale behaviour. No cross-editor formula execution was performed.

• 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 UPPER 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
• ONLYOFFICE TRIM help
• here

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.