logo
excelfunctions.org
bookmarks

JIS

Changes half-width (single-byte) characters within a string to full-width (double-byte) characters.

TextText Processing

What it does

Converts half-width chars to full-width (used in Japanese).

Syntax

JIS(text)

Arguments

  • text(text)Text to convert.

Examples

Convert Half-Width

Convert 'Excel'.

FORMULA
=JIS("Excel")
RESULT
Excel
SAMPLE DATA
A
1Text
2Excel