Description
For Double-byte character set (DBCS) languages, The WIDECHAR function Changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters.
If you want to change full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters, please use ASC function.
Syntax
WIDECHAR(text)Parameters
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 letters, text is not changed.
Examples
The example may be easier to understand if you copy the example data (include header) in the following table, and paste it in cell A1 of a new Excel worksheet. If you need to, you can adjust the column widths to see all the data.
| Formula | Result | Description |
|---|---|---|
=WIDECHAR("EXCEL") |
ＥＸＣＥＬ | single-byte characters. |
=WIDECHAR("ＥＸＣＥＬ") |
ＥＸＣＥＬ | double-byte characters, not changed. |