The Excel DBCS function converts half-width (single-byte, hankaku) characters to full-width (double-byte, zenkaku) — the exact opposite of ASC. Japanese documents often require full-width digits and letters by convention (addresses, official forms), and legacy banking systems still export names in cramped half-width katakana like ﾄｳｷｮｳ. DBCS widens all of it to proper full-width form in one formula. In Japanese-language Excel the same function appears under the name JIS.
Syntax
| Argument | Description | |
|---|---|---|
text | Required | The text to convert, or a cell reference. Half-width letters, digits, punctuation, spaces, and katakana become full-width; characters that are already full-width — and kanji — pass through unchanged. |
Available in: all Excel versions, but it performs a real conversion only when an East Asian language (Japanese, Chinese, Korean) is enabled in Office — otherwise it returns the text unchanged. In Japanese Excel this function is named JIS; DBCS and JIS are the same function.
Widening text to full-width
Three classic jobs: meeting a full-width formatting convention (rows 2–3) and rehabilitating half-width katakana from a legacy bank export (row 4):
| A | B | C | |
|---|---|---|---|
| 1 | Half-width input | =DBCS(A2) | What changed |
| 2 | EXCEL123 | ＥＸＣＥＬ１２３ | letters & digits widened |
| 3 | 100% | １００％ | digits and % widened |
| 4 | ﾄｳｷｮｳ | トウキョウ | half-width katakana restored |
Forms that demand full-width digits in addresses are a one-liner:
And because conversion is character-by-character, mixed text is safe — kanji sail through while the katakana and digits around them widen:
Try it: interactive DBCS demo
Type half-width text and watch DBCS widen it character by character.
Errors & common pitfalls
Pitfall: nothing happens on a Western-language system. Without East Asian language support, DBCS returns its input unchanged — no error. If a colleague in Tokyo gets different results from the same workbook, this is why: the conversion depends on the Office language configuration, not on the file.
Pitfall: full-width digits stop being numbers. After DBCS, １２３ is text — it won’t SUM, and it won’t match the number 123 in lookups. Widen for display at the end of a pipeline, never in the middle of calculations. ASC + VALUE reverses the damage.
Pitfall: it’s called JIS in Japanese Excel. Same function, two names. A workbook saved with JIS opens fine everywhere — but when reading documentation or recording macros, expect either name.
Pitfall: byte counts double. On a DBCS-locale system, every widened character goes from 1 byte to 2, so LENB results — and anything built on the byte-based B functions — change after a DBCS pass. Character counts via LEN stay the same.
Practice workbook
Frequently asked questions
What's the difference between DBCS and ASC?
Are DBCS and JIS the same function?
Why would I ever want full-width characters?
Why does DBCS return my text unchanged?
Master functions like this in one day
This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class