In this article
JIS converts half-width characters to full-width (double-byte), mainly for Japanese documents. It is available only when Japanese is enabled as an editing language (File > Options > Language); otherwise Excel shows #NAME?. DBCS does the same job and exists in every version.
Advertisement
Syntax
=JIS(text)| Argument | What it means |
|---|---|
text |
Text to convert |
Examples
Example 1
=JIS(A2)Result: ＡＢＣ. See the worked example table below for more cases.
JIS in practice
Where you will use it
- Japanese forms that require full-width characters
- Matching data between systems that use different widths
- Cleaning imported Japanese data
Worked example
| Text | Formula | Result |
|---|---|---|
| ABC | =JIS(A2) | ＡＢＣ |
| Excel | =JIS(A3) | Ｅｘｃｅｌ |
| 123 | =JIS(A4) | １２３ |
Not calculated here: this Excel has no Japanese editing language. With it enabled, ABC becomes ＡＢＣ.
Mistakes people make
| Mistake | What to do instead |
|---|---|
| #NAME? | Enable Japanese as an editing language, or use DBCS |
| Expecting a visible change in English | Letters become their full-width forms (ＡＢＣ) |
Related functions
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
Advertisement
✨ Ask AI about this article
Stuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong