The ASC function converts full-width (double-byte) characters that are typical for East Asian languages into standard-width (single-byte) characters.
In the spreadsheet editor, the function is only used for the backward compatibility with documents containing text encoded in DBCS.
Syntax
ASC(string)
Argument |
Description |
Permitted values |
|---|---|---|
string |
Text to be converted |
Text string or reference to a cell containing text |
Examples of use
Example of character conversion
=ASC("Ａ")
This formula will return “A” by converting a full-width character to a half-width character.
String conversion
=ASC("こんにちは")
If the string contains full-width characters, the function will return their corresponding half-width equivalents.
Use with text in a cell
=ASC(A1)
If cell A1 contains text with full-width characters, this formula converts them to half-width characters.
Notes
–The ASC function is mainly used to work with characters of different widths.
–Use the JIS function for reverse conversion.
–Single-byte characters remain unchanged.