JIS function

Category: Text
Introduced: Excel 365

Summary

Changes half-width (single-byte) characters within a 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 " "

Microsoft Support Page

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

Back to Functions