=LOWER(text)

The function takes one argument. Zoho’s official =LOWER("Zoho Sheet") example returns zoho sheet. Digits and punctuation are preserved in the ASCII worksheet examples below. The official text page does not fully specify locale-sensitive Unicode transformations.

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. In the example dataset, confirm D2 contains uppercase tag CA-0041.
2. Enter =LOWER(D2) in empty F2.
3. Expected F2: ca-0041, matching the original lowercase tag C2.
4. Fill down F2:F9 to normalize each expected tag to a lowercase comparison key.
5. Compare F values to C without replacing D; keep both forms if required for review.

Python lowercase conversion on ASCII input was used to check these displayed results independently, not to simulate or claim Zoho execution.

Advanced: compare a canonical tag with an incoming tag

Put this formula into G2:

=IF(EXACT(LOWER(D2);C2);"MATCH";"REVIEW")

Expected G2: MATCH, because D2 CA-0041 normalizes to C2 ca-0041. When copied to G3, D3 US-0087 normalizes to us-0087, matching C3. This combination separates case normalization from the case-sensitive final comparison.

For a real validation table, do not decide that a source tag is genuine merely because it matches after lowercasing. A distinct identifier could collide with another record after case normalization; investigate duplicates before using keys as permanent IDs.

• Case preservation: LOWER deliberately loses uppercase distinctions. Store the source value in a separate cell.
• Whitespace and punctuation: LOWER is not TRIM or CLEAN; it does not, by itself, remove leading/trailing spaces or embedded control characters.
• Leading zeros: Keep identifier columns formatted as text when importing. A leading-zero change caused by import cannot be fixed merely by lowercasing.
• Accent rules: Do not assume that special-language case conversions agree with Excel or Sheets without native tests.
• Incorrect input: Use the simplest one-cell formula first. The Zoho error list is general, and no example-specific error has been natively generated here.
• Expected casing: If the user-facing label should have readable capitals, PROPER is the different operation; do not use LOWER as a display-name beautifier.

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 also lists LOWER in its official text function reference. The basic one-argument ASCII example transfers conceptually. Formula separators can differ in nested formulas and locale settings, and non-ASCII casing rules may differ between engines. For cross-platform import pipelines, agree on an explicit case-normalization policy and test with sample IDs before using comparisons as integrity checks.

• UPPER
• PROPER
• CLEAN
• EXACT
• TRIM

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

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