Formualizer Docs

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

ArgumentTypeRequiredDefault
textanyRequired—

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?.

FAQ

Are non-ASCII full-width characters transliterated?

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

Implementation

Engine source

On this page