Practice free

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

Practice this in the app

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.

FormulaExcel showsCase
=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 .