DBCS
Formula Explanation
The function converts half-width (single-byte) letters in a string to full-width (double-byte) characters.
Formula Syntax
Enter in the result column: DBCS(text / column number)
The DBCS function syntax has the following argument:
- Text (required): The text or a reference to a cell containing the text that you want to convert. If the text does not contain any half-width English letters or katakana characters, it will not be converted.
Usage Example
Convert the values in column CP2 to full-width characters, and write the results into column CP3.
CP3 = DBCS(CP2)