How to use Excel ASC Function

Introduction

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.

Syntax

=ASC(Text)

Arguments

Text: It is the text or reference which contains the characters you wants to convert to single 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.

Examples

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 Reply

Close Menu
×

Cart