JIS

Formulas / JIS
Convert single byte characters into double byte characters in a specific encoding.
JIS(text)
  • text - required text or cell reference containing the text to change

Examples

  • =JIS("A1") returns "A1". JIS stands for Japanese Industrial Standard and this function returns a Japanese string based on the value given. In this example, the value "A1" is given and the function returns the same value.

  • =JIS(A2) returns the Japanese equivalent of whatever is in cell A2. For example, if cell A2 contains the text "Hello", the function will return the Japanese equivalent of that text.

  • =JIS(B1) returns the Japanese equivalent of whatever is in cell B1. For example, if cell B1 contains the number 7, the function will return the Japanese equivalent of that number.

  • =JIS(" ") returns " ". This example shows that the JIS function can also be used to return empty strings. In this example, the function returns two empty spaces, as the value given was two empty spaces.

Summary

The JIS function in Sourcetable is a text/string function which converts single character characters into double character characters. This function is useful for multiple languages and can convert unique characters to text strings.

  • The JIS function was replaced by the DBCS function in Excel 2013.
  • The JIS function is useful for multiple languages, converting single byte characters into double byte characters in a text string.


Frequently Asked Questions

What is the JIS function?
The JIS function is a function that converts half-width letters in a character string to full-width characters.
What does the JIS function change?
The JIS function changes English letters or katakana to full-width characters.
What is the argument for the JIS function?
The argument for the JIS function is a text argument.
Is the text argument required?
Yes, the text argument is required.
What does the text argument contain?
The text argument contains the text or a cell reference containing the text to change.
Does the JIS function change other text?
No, the JIS function does not change text if the text does not contain half-width English letters or katakana.

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.