ASC Function

Converts full-width (double-byte) characters to half-width (single-byte).

Category

Text

Available in

All versions, Microsoft 365

Returns

Text

Want to practice ASC in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

Japanese, Chinese and Korean keyboards can type “full-width” versions of letters and numbers — NS-1042 instead of NS-1042. They look similar but don't match in lookups.

ASC converts them to normal half-width characters (and full-width katakana to half-width), so data from different keyboards lines up.

Syntax

=ASC(text) Explain

Arguments

ArgumentRequired?What it does
textYesThe text to convert.

Examples

Example 1 — Normalising codes from a Tokyo office

Some SKUs were typed in full-width characters.

B2fx=ASC(A2)
AB
1TypedNormal
2NS-1042NS-1042
3NS-2210NS-2210
4WEST 7WEST 7
=ASC(A2) Explain

Common mistakes

  • Nothing seems to change. Text that's already half-width is returned unchanged — which is exactly what you want when cleaning a mixed column.

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.