Return the corresponding ANSI code of a character.
The Excel CODE function display a unique number of each valid character based on the underlying set standard of American National Standards Institute (ANSI). The set of such characters is called the ANSI character set, and the numbers assigned to each character are called the ANSI codes.
text – A character represented by an ANSI code.
An integer between 1 and 255.
The CODE function result is the opposite of the CHAR function.
The Microsoft Excel CODE function returns the number based on the ASCII value.
Return numbers depend upon the operating environment used by computer:
For example in Window, = CODE(!) (exclamation mark) in Excel returns 33 number.
For example in Window, = CHAR(<) (greater than Sign) in Excel returns 62 number.