SpreadJS 15
Formula Reference / Formula Functions / Text Functions / JIS
In This Topic
    JIS
    In This Topic

    This function converts half-width (single-byte) characters to full-width (double-byte) characters.

    Syntax

    JIS(text)

    Arguments

    The argument accepts a text value or a reference to a cell containing the text to be changed.

    Remarks

    This function can convert half width letter symbol, letter and katakana to full width characters.

    The text can be in number, date, string, or boolean format. If the text is not in the correct format, a #VALUE! error is returned.

    This functions is called "DBSC" when the language package is set to languages other than Japanese or German. To know more, refer to DBCS function topic.

    Data Types

    Accepts string data. Returns string data.

    Examples

    JIS("デパト") returns デパト.