Formualizer Docs
ReferenceFunctionsText Functions

ASC

Converts full-width Latin and ASCII characters to half-width text.

Summary

Maps full-width ASCII punctuation, digits, letters, and ideographic space to their half-width equivalents while leaving other characters unchanged.

Examples

Convert full-width letters and digits
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
ABC123
Convert ideographic space
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
A B

FAQ

Are non-ASCII full-width characters transliterated?

No. ASC only maps the full-width ASCII block and ideographic space.

Runtime metadata

Category

Text

Signature

ASC(arg1: Any)

Arity

min 1, max 1

Arguments

arg1

Any · Scalar

Caps

PURE

Source

crates/formualizer-eval/src/builtins/text/char_code_rept.rs

ARRAYTOTEXT

ARRAYTOTEXT: Converts an array or range into a text representation.

CHAR

Returns the character specified by a number Excel uses Windows-1252 encoding for codes 1-255.

On this page

SummaryExamplesRelated functionsFAQAre non-ASCII full-width characters transliterated?Runtime metadata