How to use Excel JIS Function

Introduction:-

JIS function in excel is a text/string function. I. This function is used to convert single byte characters into double byte characters in a text string. This function is useful for multiple languages and unique characters. Half width characters are converted to full width characters. This function was replaced by DBCS function from excel 2013 onward. For example, =JIS(“PRINCE) gives PRINCE as the result.

Syntax:-

=JIS(Text)

Arguments:-

Text: It is the text or reference which contains the characters you wants to convert to double bytes.

Keynotes:-

  • The maximum characters possible in one byte is 265 while in two bytes maximum characters possible are square of 256.
  • Japanese language characters are changed to half width while English and katakana characters are changed to full width characters.
  • This function was replaced by DBCS function from excel 2013 onwards.

Examples

In this example, some one byte values of English language are entered in column A and JIS function is used to convert these characters into two byte values.

TEXT RESULT
EXCEL EXCEL
Prince Prince
Boss Boss
Hello Hello

Leave a Reply

Close Menu
×

Cart