Practice free

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.

Practice this in the app

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.

FormulaExcel showsCase
=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.

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 .