=PROPER(text)

Zoho’s documentation gives =PROPER("zOho sheet") → Zoho Sheet and =PROPER("this is a title") → This Is A Title. No additional parameter is documented. The official description does not spell out every punctuation or language boundary rule; unusual names should be checked in the native app.

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 A2 is eAST DEPOT, and the desired display value B2 is East Depot.
2. Enter =PROPER(A2) in empty F2.
3. Expected F2: East Depot. Both words start with a capital, followed by lowercase letters.
4. Fill F2:F9 and compare each formatted name with reference column B.
5. Flag any difference for editorial or data-steward review instead of overwriting names automatically.

These common ASCII results were checked independently using Python title-style processing, which is not proof of equivalent Zoho behaviour for apostrophes, hyphens or accented letters.

Advanced: spot corrections automatically without overwriting original names

In G2, enter:

=IF(EXACT(PROPER(A2);B2);"MATCH";"REVIEW")

Expected G2: MATCH, because formatting A2 yields the canonical B2. The same formula copied to G3 gives MATCH for WEST market versus West Market. A MATCH means the values agree under the chosen simple case rule; it does not certify legal name accuracy.

You can also compare =EXACT(A2;PROPER(A2)) in H2: expected FALSE because the imported A2 is not in proper case. This flags a normalization proposal rather than changing records in place.

• Not true title-style editorial capitalization. This Is A Title capitalizes articles and short words; human title style may use different conventions.
• Acronyms and brands: NASA can become Nasa under simple word casing; preserve manually approved capitalization for acronyms and names.
• Punctuation and hyphens: Zoho’s brief function page does not enumerate exactly which punctuation creates word boundaries. Avoid relying on that without native testing.
• Multiple spaces: This changes letter case, not intended whitespace. TRIM may be needed separately.
• Names with apostrophes, Unicode letters or mixed-language text: Verify before bulk processing; independent ASCII checks do not establish a complete Unicode case algorithm.
• Non-mutating: Putting =PROPER(A2) in F2 never edits A2; keep imported source names for auditing.

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.

Excel’s PROPER reference explicitly says it capitalizes a letter after any character other than a letter. Zoho’s PROPER reference only describes the first letter of each word. Therefore we cannot assert exact punctuation-boundary equivalence between the two without live Zoho checks. Basic space-separated ASCII names generally have the same expected output in the documented examples. Google Sheets or Excel users should still review brand names and locale-specific cases after migration.

• UPPER
• LOWER
• CLEAN
• EXACT
• TRIM

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

• Zoho Sheet: PROPER function.
• Zoho Sheet: official Text function category.
• Microsoft alternative: PROPER 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.