Skip to main content

ASC function

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.

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>