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.
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:
Based on the Excel spreadsheet above, the following DBCS examples would return:
Result: Jack Albertson
Note: If the text does not contain any half-width letters, then the text will not change.