How to use the Excel ASC function

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.

Excel ASC function - How to use the Excel ASC function

Syntax: =ASC(text)

The ASC function syntax has the following arguments:

  • 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.

Example: Let’s look at some Excel ASC function examples and explore how to use the ASC function as a worksheet function in Microsoft Excel:

A B C
Syntax: =ASC(text) Result Description
=ASC(“SOPHUC”) SOPHUC single-byte characters, not changed.
=ASC(” S O P H U C “) SOPHUC double-byte characters.
=ASC(” S O P H U C C O M “) SOPHUCCOM double-byte characters.
=ASC(” S O P H U C . COM”) SOPHUC.COM double-byte characters.
READ:  How to use the Excel TIME function

Add a Comment

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