Monday, August 10, 2020

Asc function

This article describes the formula syntax and usage of the ASC function in Microsoft Excel.

Description

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

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

=ASC("EXCEL") equals "EXCEL"

=ASC(" excel excel excel excel ") equals " excel excel excel excel "

No comments:

Post a Comment