ASC Function in ONLYOFFICE Spreadsheet Editor: Syntax and Examples

=ASC("ＡＢＣ１２３") is expected to return the text ABC123. ASC can normalize full-width Latin letters, digits and punctuation before matching imported identifiers. It returns text, not character-code numbers.

Important version-specific limit: the official help describes full-width to half-width conversion broadly for double-byte character sets. The inspected 10.0.0.169 implementation converts only Unicode U+FF01 through U+FF5E. It does not convert full-width katakana or the ideographic space. Do not rely on this build’s ASC as a general Japanese width-normalization function.

=ASC(text)

The single required argument is text or a reference to a cell containing it. No optional argument or language selector exists. For each UTF-16 code unit in the supported full-width interval, the implementation subtracts hexadecimal FEE0. All other code units are copied unchanged. Thus U+FF21 Ａ becomes U+0041 A, and U+FF11 １ becomes U+0031 1.

This is a specific width mapping, not general Unicode normalization, transliteration, case conversion or an ASCII encoding operation. An output containing カ or an emoji can still contain non-ASCII characters.

1. Enter Original key in A1 and Normalized key in B1.
2. Enter the exact text samples below in A2:A6, preserving the full-width characters.
3. Enter =ASC(A2) in B2 and fill down.
4. Compare column B with the destination system’s accepted character policy before using it as a key.

The expected strings come from independent Unicode code-point subtraction. Row 5 intentionally shows the limitation: katakana カ is outside U+FF01–U+FF5E and remains unchanged. Row 6 is text 12.50, not a numeric result; converting that text to a number is a separate, locale-sensitive decision.

A supplier may send both ＡＢＣ－１２ and ABC-12. ASC maps both to ABC-12. That may be useful when they are two spellings of the same key, but it can also merge records that were previously distinct. Preserve the raw supplier key, create a separate normalized column and review duplicates before using the normalized value in a lookup or deduplication operation.

The ideographic space 　 (U+3000) is not the ordinary ASCII space. In =ASC("Ａ　Ｂ"), the expected result is A　B, retaining that full-width space. If the receiving system requires ordinary spaces, make a separate explicit substitution after deciding that transformation is appropriate. Do not assume TRIM or CLEAN performs every Unicode-space normalization.

The length guard is based on JavaScript string length, which counts UTF-16 code units. A supplementary-plane character may occupy two code units, so “255 characters” is not a safe description for every Unicode string. The implementation checks length before conversion. Do not work around a failed long input by assuming it was partially converted.

For reliable batch processing, use one text cell per formula and keep the original data nearby. Range and array inputs have additional coercion and selection paths; this guide’s worked examples establish only the scalar text workflow. Cross-application functions with the same name may implement broader DBCS mappings, so compare representative characters before transferring a normalization process.

The official ASC reference was checked on October 18, 2026. The implementation discussion uses official SDKJS source tagged v10.0.0.169, matching the version/build designation of Desktop Editors 10.0.0-169. Desktop Editors 10.0 was released on October 13, 2026. The first version introducing this individual function is not established by these sources. Current documentation does not mark it retired or deprecated.

Examples in this guide are expected results from documentation, source inspection and independent calculations, not results observed in the application. They have not been tested in the application or its calculation engine. The unversioned help and pinned source do not establish identical behavior in older versions, mobile clients, every server deployment or imported workbooks. Examples use English names and comma argument separators; adapt formula-entry separators to your editor settings.

• SUBSTITUTE
• LEN
• TRIM
• CLEAN