Excel like a finance pro.
← The libraryPractice · 2 questions →
Text function
DBCS
Converts half-width single-byte characters to full-width double-byte characters.
Rarely usedDifficulty 1300 · ProficientUsage rank #301 of 520
When to use it
Converts half-width characters to full-width (double-byte) in DBCS languages.
The shape of it
- Syntax
=DBCS(text)
Worked examples
Letters
=DBCS("EXCEL") → ＥＸＣＥＬ
Standard letters to full-width.
Digits
=DBCS("123") → １２３
Digits to full-width.
Non-DBCS system
=DBCS(A2) → unchanged
On a system without a DBCS language the text comes back as is.
Worth knowing
- Used to match legacy data stored in full-width form.
- ASC reverses it.
- JIS is the same function under its older name.
Where it goes wrong
- No effect on non-DBCS systems.
- Full-width text will not match half-width lookups.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.