This article describes the formula syntax and usage of the JIS function (function: A prewritten formula that takes a value or values, performs an operation, and returns a value or values. Use functions to simplify and shorten formulas on a worksheet, especially those that perform lengthy or complex calculations.) in Microsoft Excel.
The function described in this Help topic converts half-width (single-byte) letters within a character string to full-width (double-byte) characters. The name of the function (and the characters that it converts) depends upon your language settings.
For Japanese, this function changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters.
The JIS function syntax has the following argument (argument: A value that provides information to an action, an event, a method, a property, a function, or a procedure.):
- 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.
=JIS("EXCEL") equals "EXCEL"
=JIS(" ") equals " "