For Double-byte character set (DBCS) languages, changes full-width (double-byte) characters to half-width (single-byte) characters.
Syntax
ASC(text)
Text is the text or a column reference that contains the text you want to change. If text does not contain any full-width letters, text is not changed.
Examples
Formula |
Description (Result) |
=ASC(" ") |
" " |
=ASC("EXCEL") |
"EXCEL" |