Skip to main content

WIDECHAR function


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.




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.


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") EXCEL single-byte characters.
=WIDECHAR("EXCEL") EXCEL double-byte characters, not changed.

Leave a comment

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

Format your code: <pre><code class="language-vba">place your code here</code></pre>