UPPER in WPS Spreadsheet: Standardize Codes and Audit Case Changes
Use UPPER in WPS Spreadsheet for uppercase codes, controlled cleanup and case-sensitive before-and-after checks.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: UPPER converts lowercase letters in text to uppercase. For example, =UPPER("item-b07") is expected to return ITEM-B07. Digits and punctuation retain their positions.
Availability and version history
- Introduced: documented by 2019-06-24 in the official WPS lesson; original introduction is not established.
- Availability: WPS Office for Windows Personal; numeric release not identified in the lesson. This is documentation evidence, not an installed-build guarantee.
- Scope: the exact supported build range is unverified. The cited Windows lesson does not establish equivalent availability in other WPS clients.
- Checked: October 14, 2026 against the function-specific lesson and vendor catalogue. Examples were independently calculated; no new native WPS test was performed.
Syntax
=UPPER(text)
text is the string or cell reference to convert. For a stored value, enter =UPPER(A2) in another cell. For a direct test, enter =UPPER("abc"), which is expected to return ABC.
The official Windows lesson documents English case conversion and says non-letter characters are unchanged. The examples here use ASCII letters. Check language-specific letter behavior in the intended installation before normalizing international names or identifiers.
Example 1: create uppercase reporting codes
Enter this dataset in A1:B5:
| Row | A: Original code | B: Description |
|---|---|---|
| 1 | Original code | Description |
| 2 | part-a12 | Bracket |
| 3 | Part-b03 | Clip |
| 4 | PART-C40 | Plate |
| 5 | kit_009 | Kit |
In C2 enter and fill down:
=UPPER(A2)
Expected C2:C5: PART-A12, PART-B03, PART-C40, KIT_009.
The underscore stays an underscore. UPPER does not enforce a code schema, so a rule that requires hyphens still needs a separate check. It also does not modify A2:A5; the normalized outputs remain formulas linked to the originals.
Example 2: spaces are a separate issue
Put west bin in E2 with two ordinary spaces at the beginning, between the words and at the end.
=UPPER(E2)
Expected result: WEST BIN , preserving the spaces. If the reporting standard calls for a single space between words and none at either end, use:
=UPPER(TRIM(E2))
Expected result: WEST BIN. TRIM changes spacing; UPPER changes case. Keep them separate in helper columns when reviewing an unfamiliar import, so you can see which rule caused each change.
Example 3: combine an approved code with a label
With part-a12 in A2, enter:
="ITEM: "&UPPER(A2)
Expected result: ITEM: PART-A12. The fixed label is text in quotes; the ampersand joins the label and converted code.
If B2 contains the description Bracket, this formula preserves that description’s case:
=UPPER(A2)&" - "&B2
Expected result: PART-A12 - Bracket. Applying UPPER to the entire expression instead would also capitalize the description. Place the function around exactly the part that should change.
Advanced example: find which records were already standardized
After calculating the uppercase value in C2, use D2:
=IF(EXACT(A2,C2),"Already uppercase","Case changed")
Fill down. Expected D2:D5: Case changed, Case changed, Already uppercase, Case changed.
The EXACT function checks case-sensitive equality. This is more informative than looking at a font that makes upper- and lowercase characters difficult to distinguish.
For a case-normalized comparison without helper cells:
=EXACT(UPPER("bin-a"),UPPER("BIN-A"))
Expected result: TRUE. Changing the second argument to "BIN_A" gives FALSE because the separator differs. Normalizing case must not silently erase punctuation differences that distinguish valid keys.
Limits and troubleshooting
UPPER does not correct spelling, remove hidden characters, translate text or change the source value in place. A result that still fails a lookup may contain extra spaces, a different separator or an invalid identifier. Use LEN to compare lengths and inspect the source before adding more transformations.
Avoid applying UPPER indiscriminately to passwords, case-sensitive file paths or externally assigned IDs. A reporting display can use a standardized form while the original remains the authoritative value. If a formula appears as literal text, check the equals sign, quotes and cell format first.
Before filling a long column, test one lowercase value, one already-uppercase value and one mixed-case value. Add a punctuation test and a spacing test. Those simple cases expose whether your chosen normalization rule matches the actual reporting requirement.
References and verification
- Official WPS UPPER lesson, published 2019-06-24 (Chinese; Windows Personal scope).
- WPS UPPER documentation catalogue.
The lesson establishes the function-specific behavior discussed here. The catalogue confirms its listed identity, not an exact current build range. Expected outputs use original examples checked independently; native execution and broader client compatibility remain unverified.