An imported identifier may start with a space, a punctuation symbol, or the wrong prefix. CODE gives you a numeric first-character indicator. Use it for lightweight checks on known ASCII data such as standard uppercase A–Z, but do not treat it as a complete Unicode validator or a data-cleaning function.

=CODE(text)

Zoho says CODE returns a numeric character code in the 0–255 range. Its own examples include =CODE("%") → 37, =CODE("e") → 101, and =CODE("Zoho") → 90. These examples do not establish what CODE returns for every Unicode character, an empty string or the first character of an unformatted numeric value. Those cases remain native-test items.

Version, platform and locale scope

The syntax below is taken from Zoho Sheet’s current public English online function reference checked October 11, 2026. That reference does not identify the first Zoho release supporting this function or prove identical behaviour across historical releases, desktop wrappers, iOS, Android, or account configurations. No such first-supported version is claimed here. The published Zoho examples use semicolons (;) between arguments; syntax displayed by a localized application should be checked in its formula helper rather than copying separators from Excel. Zoho documents spreadsheet locale controls for number, date, currency, and decimal formats. Do not assume text that looks like a number will parse identically under all locales. Zoho locale settings.

Use a new Zoho Sheet spreadsheet. Create these six column headings in row 1, then enter the eight example rows. Select column E as text before entering values, because these are intentionally imported-looking numeric strings; a CSV import may otherwise turn them into numbers. Keep order identifiers in A as text. If importing the included CSV, inspect column types afterward and correct them before comparing formulas. The examples use fictitious records only.

A formula such as =B2 references the first data row, not the header. Enter examples in blank cells, or create a separate Results sheet and select the sample cells to form explicit references. When copying a formula down, check the references advance to the correct rows. Set result cells to General where you want to see the returned value without extra display formatting.

1. Enter =CODE("Zoho") in a free cell; expected 90 because the first character is Z, not o.
2. Enter =CODE("%"); expected 37.
3. Enter =CODE("e"); expected 101.
4. Enter =CODE(B2); since B2 is Ada, expected 65 for A.
5. Enter =CODE(B3); since B3 is Ben, expected 66 for B.
6. Enter =CODE("Ada"); expected 65. A complete name does not change the fact that CODE returns only the first character’s code.

Suppose a temporary import quality check should label records beginning with an ASCII uppercase A. Place this formula in a helper cell:

=IF(CODE(B2)=65;"A-initial";"Other")

For Ada (B2) the expected result is A-initial; changing the reference to B3 (Ben) gives Other. This is a narrow ASCII check: it is not a general case-insensitive comparison, and it should not be used to validate real people’s names. A value with an unwanted leading space will be classified differently; check the original source rather than silently trimming it unless that transformation is appropriate.

For a reversible sanity check within common ASCII: =CODE(CHAR(65)) is expected to yield 65. Avoid generalizing this round trip to undefined or extended character mappings.

Zoho documents the return code range of 0–255; this is not proof that every possible encoded character or emoji is representable. An empty text argument, multibyte Unicode, surrogate pairs and locale-specific behavior were not natively tested for this guide.

Excel’s CODE function also returns the code for the first character, but Microsoft notes that the underlying character set is the one used by the computer. This is a reason to be cautious with non-ASCII character codes during imports, especially when comparing Excel on different platforms with cloud spreadsheets. A familiar ASCII check (CODE("A") → 65) is appropriate for validating a straightforward example; matching symbols above 127 requires direct application testing. Google Sheets compatibility is not assumed for unsupported code ranges.

Quick questions

Does CODE convert all of Zoho into four numbers? No, it examines the first character and returns a single code.

What if a name starts with a space? The first character is then the space; confirm whether the space should be removed before applying CODE.

Can CODE compare names? It cannot compare entire strings. Use a comparison function for that purpose; CODE is a narrow first-character diagnostic.

• CONCATENATE — join several text values.
• REPT — repeat text without building a string manually.
• CHAR — get a character from its numeric code.
• CODE — inspect the first character’s code.
• VALUE — convert text representing a number into a numeric result.
• LEFT, LEN, TEXTJOIN, and TRIM — related text tools under review.

• Zoho Sheet — function documentation
• Zoho locale settings

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.