# How to Use JIS Function in Excel

This guide will explain how to use the JIS function in Excel.

The Japanese Industrial Standard or JIS is a set of standards and specifications established by Japanese-based enterprises to ensure uniformity and compatibility within the industry.

One of these standards is the JIS encoding standard. This standard defines specific numeric codes for Japanese characters, including Kanji, Hiragana, and Katakana.

When working with Excel formulas that involve Japanese text, you may need to ensure that the character encoding matches the JIS standard. Incorrect encoding can result in garbled or incorrect text in your formulas and cell values.

Excel has a `JIS` function that converts half-width (single-byte) letters within a character string to full-width (double-byte) characters. In this guide, we will provide a step-by-step tutorial on how to use the `JIS` function in Excel.

## The Anatomy of the JIS Function

The syntax of the `JIS` function is as follows:

`=JIS(text)`

Let’s look at each argument to understand how to use the `JIS` function.

• JIS() refers to our `JIS` function. This function accepts a text value and returns a modified string where each character is a full-width character.
• text refers to the text you want to change. This argument could be the actual text value or a cell reference containing a text value.
• If the text argument contains no half-width English letters or katakana, the text is not changed.

## A Real Example of Using the JIS Function in Excel

Let’s explore a simple example where we can use the `JIS` function in Excel.

In the table above, we have a table containing text strings that we want to convert into full-width characters. For example, providing the string “hello!” will return the string “ｈｅｌｌｏ” instead.

We can use the following formula to convert the text in cell A2 to use full-width characters:

`=JIS(A2)`

In our table above, we’ve converted both English letters and Japanese katakana to full-width characters.

### Setting the preferred authoring language to Japanese

The JIS function may only work in Excel if Japanese is set as the preferred language in your program’s settings.

You can find the Language preferences by selecting File > Options and navigating to the Language tab. If Japanese has not yet been added as an authoring language, click the Add a Language option.

Click on the link below to create your own copy of our example.

Head to the next section to read our step-by-step guide on how to use the `JIS` function in Excel.

## How to Use the JIS Function in Excel

1. Select the cell where you wish to add the `JIS` function.
In our example above, we’ll use cell B2 to hold our first `JIS` function. We will copy the formula later to fill the rest of the column.
2. Type the `JIS` function and provide the argument you want to convert to full-width text. This argument could be a text value or a cell reference.
3. Hit the Enter key to evaluate the function.
4. Use the AutoFill feature to copy the `JIS` function across the whole column.
5. You can use the `DBCS` function instead if your version of Excel does not support the `JIS` function.
For example, in the web version of Excel, the `JIS` function has been replaced with the `DBCS` function. The `DBCS` has the same functionality as the `JIS` function.

These are all the steps you need to know to start using the `JIS` function in Excel.

## FAQs

1. How do I convert full-width characters back to half-width characters in Excel?
Excel comes with the `ASC` function, which converts full-width ASCII and katakana characters to an equivalent half-width character. For example, the formula =ASC(“グーグル”) will return the string “ｸﾞｰｸﾞﾙ”.

To learn more about using Excel for manipulating text with double-byte characters, you can read our post on how to use the `FINDB` function in Excel. You may also be interested in our guide on how to rotate text in Excel.

That’s all for this guide! Be sure to check out our library of spreadsheet resources, tips, and tricks!

### Get emails from us about Excel.

Our goal this year is to create lots of rich, bite-sized tutorials for Excel users like you. If you liked this one, you'd love what we are working on! Readers receive early access to new content.

## How to Lock a Structured Reference in Excel

This guide will explain how to lock a structured reference in Excel. The structured reference syntax is a…

## How to Fix Formula Not Showing Correct Result in Excel

This tutorial will explain a few ways to fix formulas not showing the correct result in Excel. Microsoft…

## How to Ignore #N/A Values in Excel

This guide will discuss how to ignore #N/A values in Excel using the IFNA function.  The rules for…

## How To Calculate Skewness in Excel

This guide will explain how to calculate skewness in Excel. Skewness is a measure of symmetry that statisticians…