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

ArgumentRequired?What it does
textYesThe text to convert.

Examples

Example 1 — Full-width for a Japanese form

Convert codes to full-width characters.

B2fx=DBCS(A2)
AB
1CodeFull-width
2NS-1042NS-1042
3Excel 1Excel 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.
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.