=UPPER(text)

There is one argument, so no argument separator is needed. Zoho’s official example =UPPER("Zoho Sheet") yields ZOHO SHEET. Documentation inconsistency: the same official page shows =UPPER("FUNCTION") producing FUNCTIONS, even though adding an S contradicts the described uppercase-only operation. Treat that displayed example as inconsistent; it has not been reproduced in Zoho Sheet. =UPPER("FUNCTION") would be expected to return FUNCTION under the documented operation. Characters without case—digits, hyphens and spaces—remain in place in these ASCII examples. Do not infer locale-specific Unicode case mappings from these examples.

For repeatable examples, create a new, empty Zoho Sheet and paste or import the companion CSV batches/zoho-sheet/2026-10-11T0745Z-text-case-clean-batch08/zoho-text-clean-case-practice.csv beginning at A1. Its first row is the header; rows 2 through 9 contain the fictitious records below. Keep identifier columns C and D formatted as text so values such as ca-0041 retain their zeros and hyphen. Compare the imported cells to the table before calculating; an import tool can change apparent values.

Use empty cells starting in F2 for demonstration formulas. Do not paste output formulas on top of source columns A:D. All expected results refer to the listed source data, not a live or connected customer database.

1. Verify C2 is the literal text ca-0041 and D2 is CA-0041.
2. Click empty F2 and enter =UPPER(C2).
3. Expected F2: CA-0041. The four digits and hyphen are retained.
4. Copy the formula down through F9 to normalize each tag; compare each row to column D.
5. Keep the unmodified C values for audit rather than overwriting them with the formula output.

These outcomes were independently checked using Python uppercase conversion on the ASCII demonstration values; no Zoho spreadsheet execution occurred.

Advanced: flag a normalized identifier that does not match the approved code

With the same table and an empty G2, enter:

=IF(EXACT(UPPER(C2);D2);"MATCH";"CHECK")

Expected G2: MATCH. Explanation: C2 becomes CA-0041; D2 already equals CA-0041; EXACT compares the two, and IF chooses MATCH. This is a documentation-derived combination, not a native test. Repeat for row 3: UPPER("us-0087") equals US-0087, also producing MATCH.

To find suspicious values rather than silently fixing them, place =EXACT(C2;D2) in H2. For row 2, it returns an expected FALSE because ca-0041 is not identical in case to CA-0041. The distinction between “raw exact match” and “normalized match” is important when validating identifiers.

• UPPER is not PROPER. EAST DEPOT is useful for a code or heading but not usually for a formatted contact name; PROPER has a different capitalization goal.
• UPPER is not a text-cleaning operation. Embedded tabs, line breaks and extra spaces remain unless processed separately; use CLEAN or TRIM where appropriate.
• Case normalization can hide differences. Never overwrite the original if the source capitalization matters to a business key or audit.
• Non-ASCII and language rules: The official reference does not specify how every accented letter or locale-specific letter maps; these need native testing.
• Numbers and dates: Do not treat a normalized output as proof that identifiers were imported as text; review leading zeros in the original cell.
• No direct data mutation: A formula’s text result is calculated in its output cell; it does not convert C2 in place.

Universal troubleshooting checklist

1. Check that the intended cell is text, not a date, number or imported value reinterpreted by the editor.
2. Confirm that the function name is spelled correctly and that text literals use straight double quotation marks.
3. Recheck the cell address and the contents of the specific input row; copying a formula downward changes relative references.
4. If a formula unexpectedly shows #NAME!, inspect the function spelling and quoted literals. A #REF! may indicate an invalid or removed reference; #VALUE! is a common argument-type warning. Zoho’s generic error table does not establish that each sample here produces these errors.
5. When a nested formula fails, calculate each inner expression in its own helper cell and compare with the stated expected result before combining the functions.
6. If behaviour differs from these documentation-derived expectations, capture the Zoho Sheet environment, account locale, formula and actual displayed result for editorial review; do not quietly replace documentation claims with guesses.

Microsoft Excel documents UPPER as a text function too, so basic ASCII-uppercase formulas can be conceptually ported. Do not assume locale-sensitive Unicode mappings match across engines. Where additional IF/EXACT arguments are present, Zoho’s documented examples use semicolons; Excel examples commonly use commas in English-language installations. Adjust separators to the target app and locale, and test on actual data rather than assuming parser compatibility. Excel’s text function reference confirms the analogous function category.

• LOWER
• PROPER
• CLEAN
• EXACT
• TRIM

Official and external references (retrieved October 11, 2026):

• Zoho Sheet: UPPER function.
• Zoho Sheet: official Text function category.
• Microsoft alternative: UPPER or related text documentation.

• Zoho Sheet — function documentation
• official Text function category

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

• No genuine Zoho Sheet screenshots are included; this guide does not use mock application images.