Description
For Double-byte character set (DBCS) languages, The ASC function changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters.
If you want to change half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters, please use WIDECHAR function.
Syntax
ASC(text)
Parameters
Text Required. The text or a reference to a cell that contains the text you want to change. If text does not contain any full-width letters, text is not changed.
Examples
The example may be easier to understand if you copy the example data (include header) in the following table, and paste it in cell A1 of a new Excel worksheet. If you need to, you can adjust the column widths to see all the data.
Formula | Result | Description |
---|---|---|
=ASC("EXCEL") |
EXCEL | single-byte characters, not changed. |
=ASC("EXCEL") |
EXCEL | double-byte characters. |
=ASC("EXCELBABY.COM") |
EXCELBABY.COM | double-byte characters. |