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
| Argument | Required? | What it does |
|---|---|---|
| text | Yes | The text to convert. |
Examples
Example 1 — Normalising codes from a Tokyo office
Some SKUs were typed in full-width characters.
B2fx=ASC(A2)
| A | B | |
|---|---|---|
| 1 | Typed | Normal |
| 2 | NS-1042 | NS-1042 |
| 3 | NS-2210 | NS-2210 |
| 4 | WEST 7 | WEST 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

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.