ASC function

This article describes the formula syntax and usage of the ASC function (function: A prewritten formula that takes a value or values, performs an operation, and returns a value or values. Use functions to simplify and shorten formulas on a worksheet, especially those that perform lengthy or complex calculations.) in Microsoft Excel.

Description

For Double-byte character set (DBCS) languages, changes full-width (double-byte) characters to half-width (single-byte) characters.

Syntax

ASC(text)

The ASC function syntax has the following arguments (argument: A value that provides information to an action, an event, a method, a property, a function, or a procedure.):

  • 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

=ASC("EXCEL") equals "EXCEL"

=ASC("Excel Excel Excel Excel ") equals "Excel Excel Excel Excel "

 
 
Applies to:
Excel 2010, Excel Web App, SharePoint Online for enterprises, SharePoint Online for professionals and small businesses