DBCS function

Se aplica a
Excel para Microsoft 365 Excel para Microsoft 365 para Mac Excel 2024 Excel 2024 para Mac Excel 2021 Excel 2021 para Mac Excel 2019 Excel 2016

This article describes the formula syntax and usage of the DBCS function in Microsoft Excel.

Description

The function described in this Help topic 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

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(" excel excel excel excel ") equals " excel excel excel excel "