JIS function

This article describes the formula syntax and usage of the JIS function in Microsoft Excel.


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.



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.


=JIS("EXCEL") equals "EXCEL"

=JIS(" excel excel excel excel ") equals " excel excel excel excel "

Applies To: Excel 2016 for Mac, Excel 2007, Excel Starter, SharePoint Online, Excel 2010, Excel Online, Excel for Mac 2011

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Change language