ASC
Converts full-width Latin and ASCII characters to half-width text.
Maps full-width ASCII punctuation, digits, letters, and ideographic space to their half-width equivalents while leaving other characters unchanged.
The Formualizer engine in this repository at 0.14.0 plus unreleased changes computes the example results. Known differences from Excel are listed on this page.
Syntax
=ASC(text)
Arguments
| Argument | Type | Required | Default |
|---|---|---|---|
text | any | Required | — |
Return type
Can return text.
Examples
Convert full-width Latin letters and digits to their narrow forms.
Formula =ASC("ABC123")
Expected result ABC123
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.
Convert a mixture of wide and narrow characters.
Formula =ASC("ABC")
Expected result ABC
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.
An empty input produces empty text.
Formula =ASC("")
Expected result ""
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.
An error in the text argument propagates.
Formula =ASC(1/0)
Expected result #DIV/0!
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.
Convert ideographic space
Formula =ASC("A B")
Expected result A B
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.
Related functions
FAQ
Are non-ASCII full-width characters transliterated?
No. ASC only maps the full-width ASCII block and ideographic space.