ASC function
ASC converts full-width (double-byte) characters to half-width (single-byte). It only does anything in East Asian language setups such as Japanese; elsewhere it returns the text unchanged.
Example
Read it as a sentence: convert the text in F1 to half-width characters, which leaves an empty cell empty.
Excel shows
F
1
Data
Syntax
ASC(text)
-
text(required) - The text whose full-width characters should be converted.
Returns: Text with full-width letters and katakana converted to half-width.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=ASC("ABC123") | ABC123 | Full-width letters and digits |
=ASC("abc") | abc | Already half-width |
=ASC(123) | 123 | Number |
=ASC(Data!F1) | Blank |
The Data sheet these formulas read
A cell that starts with = holds that formula.
F
1
Data
Watch out for
- Has no visible effect unless a double-byte language is enabled.
- Opposite of DBCS.
Where it works
- Excel
- ASC is in every version of Excel from 2007 on. Only changes text in East Asian (double-byte) language settings.
- Google Sheets
- No direct equivalent. No direct counterpart; REGEXREPLACE or a lookup table can emulate it.
Part of Text functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .