DBCS function
DBCS converts half-width letters and katakana in text to full-width characters. It only has an effect when an East Asian language such as Japanese is enabled, and otherwise returns the text unchanged.
Example
A
B
C
D
1
ABC
2
3
Syntax
DBCS(text)
-
text(required) - The text whose half-width characters should be widened.
Returns: Text with half-width letters and katakana converted to full-width.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=DBCS("ABC123") | ABC123 | Half-width letters |
=DBCS(1) | 1 | Number |
Watch out for
- No visible change outside double-byte language settings.
- Opposite of ASC.
Where it works
- Excel
- DBCS is in every version of Excel from 2007 on. Only changes text in East Asian (double-byte) language settings.
- Google Sheets
- No direct equivalent. No direct counterpart.
Part of Text functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .