DBCS function: Description, Usage, Syntax, Examples and Explanation

What is DBCS function in Excel?

DBCS function is one of TEXT functions in Microsoft Excel that converts half-width (single-byte) letters within a character string to full-width (double-byte) characters. The name of the function (and the characters that it converts) depends upon your language settings.

For Japanese, this function changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters.

Syntax of DBCS function

DBCS(text)

The DBCS function syntax has the following argument:

  • Text :  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(” excel excel excel excel “) equals ” excel excel excel excel ”

Leave a Reply

Your email address will not be published. Required fields are marked *