DBCS Function
Converts half-width (single-byte) characters to full-width (double-byte).
Category
Text
Available in
All versions, Microsoft 365
Returns
Text
Want to practice DBCS 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
DBCS is the reverse of ASC: it turns normal letters, numbers, spaces and half-width katakana into their full-width forms.
Use it when a Japanese, Chinese or Korean system expects full-width input.
Syntax
=DBCS(text) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| text | Yes | The text to convert. |
Examples
Example 1 — Full-width for a Japanese form
Convert codes to full-width characters.
B2fx=DBCS(A2)
| A | B | |
|---|---|---|
| 1 | Code | Full-width |
| 2 | NS-1042 | NS-1042 |
| 3 | Excel 1 | Excel 1 |
=DBCS(A2) Explain
Common mistakes
- Lookups stop matching. Full-width text doesn't match half-width text. Keep the original for lookups and convert only for output.
Notes
- Related functions: ASC.

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.