DBCS function

Category: Text
Introduced: Excel 365

Summary

Changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters

Syntax

DBCS(text) The DBCS function syntax has the following argument:
• Text Required. The text or a reference to a cell that contains the text you want to change. If text does not contain any half-width English letters or katakana, text is not changed.

Example

=DBCS("EXCEL") equals "EXCEL"
=DBCS(" ") equals " "

Microsoft Support Page

https://support.microsoft.com/en-us/office/dbcs-function-a4025e73-63d2-4958-9423-21a24794c9e5

Back to Functions