ASC

Converts double-byte (full-width) characters to single-byte (half-width) ASCII and katakana characters.

See https://wiki.documentfoundation.org/Calc/Features/JIS-and-ASC-functions for a conversion table.

Syntax

ASC(Text)

Text: the text string that contains characters to be converted.

Applying the ASC function to a string composed of single-byte characters will return the input string without any modifications.

Examples

=ASC("Office") returns the string "Office". No modifications were made because all characters are single-byte characters.

=ASC("ライト") returns the string "ﾗｲﾄ", which is composed of single-byte characters.

Related Topics

• JIS
• Text Functions