Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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"

Need more help?

Expand your skills

EXPLORE TRAINING >

Get new features first

JOIN MICROSOFT 365 INSIDERS >

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×