The JIS function converts standard-width (single-byte) characters into full-width (double-byte) characters that are typical for East Asian languages.
In the spreadsheet editor, this function is used to correctly display Japanese characters and symbols in the document.
Syntax
JIS(string)
Argument |
Description |
Permitted values |
|---|---|---|
string |
Text to be converted |
Text string or reference to a cell containing text |
Examples of use
Conversion of half-width katakana
=JIS("ﾊﾝｶｸ")
Result: "ハンカク" (full-width characters).
Conversion of Latin letters and numbers
=JIS("ABC123")
Result: “ＡＢＣ１２３” (Latin letters and numbers are also converted to full-width characters).
Notes
–The JIS function is the inverse of the ASC function.
–The function does not change characters that are already full-width.