Table of Contents
The JIS function in Excel allows users to convert Japanese characters into their corresponding numerical code. To perform this function, first select the cell where the converted code will appear. Then, type “=JIS(” followed by the Japanese characters in quotation marks. Pressing Enter will return the numerical code for the characters. This function is useful for data analysis and sorting in Excel.
This article describes the formula syntax and usage of the JIS function in Microsoft Excel.
Description
The function described in this Help topic converts half-width (single-byte) letters within a character string to full-width (double-byte) characters. The name of the function (and the characters that it converts) depends upon your language settings.
For Japanese, this function changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters.
Syntax
JIS(text)
The JIS function syntax has the following argument:
Text Required. The text or a reference to a cell that contains the text you want to change. If text does not contain any half-width English letters or katakana, text is not changed.
Example
=JIS(“EXCEL”) equals “EXCEL”
=JIS(” 
“) equals ” 
“
Cite this article
stats writer (2024). How can I perform the JIS function in Excel?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-perform-the-jis-function-in-excel/
stats writer. "How can I perform the JIS function in Excel?." PSYCHOLOGICAL SCALES, 30 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-perform-the-jis-function-in-excel/.
stats writer. "How can I perform the JIS function in Excel?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-perform-the-jis-function-in-excel/.
stats writer (2024) 'How can I perform the JIS function in Excel?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-perform-the-jis-function-in-excel/.
[1] stats writer, "How can I perform the JIS function in Excel?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I perform the JIS function in Excel?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.