How to Use the JIS Function in Excel

JIS function in Excel and Google Sheets

Overview

The JIS function in Microsoft Excel and Google Sheets transforms English letters or katakana from half-width (single-byte) characters to full-width (double-byte) characters within a text string.

Syntax

The syntax for the JIS function is:

JIS(text)

• text – This is the string that contains the half-width characters you wish to convert to full-width characters.

Example 1

Consider a scenario where cell A1 has the text: “Excel is awesome.”

To convert the half-width English characters to their full-width counterparts, use the formula:

=JIS(A1)

The output will be: “Ｅｘｃｅｌ ｉｓ ａｗｅｓｏｍｅ．”

Example 2

The JIS function can also be applied directly to a text string, not just cell references. For instance:

=JIS("Google Sheets")

This formula will return: “Ｇｏｏｇｌｅ Ｓｈｅｅｔｓ”

Use case

The JIS function is especially valuable in contexts that require the use of full-width characters, such as document preparation for printing or designing engaging presentations in languages that utilize double-byte characters.

Although not typically used for regular data manipulation, the JIS function is incredibly useful for specific localization needs.

More information: https://support.microsoft.com/en-us/office/jis-function-b72fb1a7-ba52-448a-b7d3-d2610868b7e2