Quick Navigation
DBCS Function
Summary
The Excel DBCS function converts half-width (single-byte) characters within a text string to full-width (double-byte) characters. This is particularly useful for Japanese text processing where half-width English letters or katakana need to be transformed into their full-width equivalents based on your system's language settings.
Syntax
DBCS(text)Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| text | Text |
Yes | Text string or cell reference with half-width characters to be converted to full-width format |
Using the DBCS Function
DBCS is a specialized text function designed for East Asian language support in Excel, particularly Japanese. It automatically detects and converts half-width English letters and katakana characters to their full-width counterparts, ensuring consistent text presentation in documents that mix Roman and Japanese characters.
Common DBCS Examples
Basic DBCS Conversion
=DBCS("EXCEL")Converts half-width 'EXCEL' to full-width Japanese-style characters (visual result depends on font/language settings)
Empty String Handling
=DBCS("")Returns empty string unchanged since no convertible characters present
Mixed Text Example
=DBCS("ABCカタカナ")Converts half-width A,B,C and katakana to full-width equivalents
Frequently Asked Questions
Common Errors and Solutions
#VALUE! error
Cause: Invalid text argument provided
Solution: Ensure text parameter contains valid text string or cell reference
Notes
- DBCS behavior depends on system language settings
- Full-width characters appear wider and are standard in Japanese typography
- Useful when preparing data for Japanese printing or display systems
- Consider JIS standards for proper East Asian text handling
Compatibility
Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365
Not available in:
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+