How to use Excel ASC Function


ACS in excel is a text/string function. It is used in case of double byte character set to convert full width(double-byte) to half width(single-byte) characters. This function is useful for multiple languages and unique characters. For example, =ASC(“PRINCE”)gives PRINCE as the result.




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


  • 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.


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

Leave a Comment

Your email address will not be published. Required fields are marked *