June 18, 2021

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:

DBCS Function - How to use DBCS Function in Excel

Syntax:  =DBCS(A2)


DBCS Function in Excel - How to use DBCS Function in Excel

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

Syntax: =DBCS(A3)
Result: Jack Albertson

Syntax: =DBCS(A4)
Result: sophuc

Syntax: =DBCS(A5)
Result: Boss

Syntax: =DBCS(A6)
Result: Potato

Syntax: =DBCS(A7)
Result: Solutions

Syntax: =DBCS(A8)
Result: Eddie

Syntax: =DBCS(A9)
Result: Thomas

Syntax: =DBCS(A10)
Result: Brown

Syntax: =DBCS(A11)
Result: Jack

Syntax: =DBCS(A12)
Result: White

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

READ:  How to use the Excel MID function

Leave a Reply

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