How to use DBCS Function in Excel

DBCS function in excel is a text/string function. Its full form is (Double Byte Character Set). This function is used to convert single byte characters into double byte characters in a text string. This function is useful for multiple languages and unique characters. Half width characters are converted to full width characters. For example, =DBCS(“PRINCE) gives PRINCE as the result.

Syntax:= DBCS(text)

The DBCS function syntax has the following arguments:

• 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: Let’s look at some Excel DBCS function examples and explore how to use the DBCS function as a worksheet function in Microsoft Excel:

Syntax:  =DBCS(A2)

Result:

Based on the Excel spreadsheet above, the following DBCS examples would return:

Note: If the text does not contain any half-width letters, then the text will not change.