The DBCS function converts standard-width (single-byte) characters into full-width (double-byte) characters that are typical for East Asian languages.
In the spreadsheet editor, the function is only used for the backward compatibility with documents containing text encoded in either ASCII or DBCS.
This is especially useful when working with text in languages that use double-byte characters, such as Chinese, Japanese, or Korean.
Syntax
DBCS(string)
Argument |
Description |
Permitted values |
|---|---|---|
string |
Text to be converted |
Text string or reference to a cell containing text |
Example of use
Mixed text
=DBCS("Hello 你好")
This formula converts a string containing English and Chinese characters into double-byte format.
Notes
If the string is already in double-byte format, the DBCS function will not change it.