Excel Code Function ANSI Value

May 11, 2015 Excel Formulas No comments

What Does It Do?

This function shows the ANSI value of a single character, or the first character in a piece of text.

The ANSI character set is used by Windows to identify each keyboard character by using a unique number.

There are 255 characters in the ANSI set.

Syntax

=CODE(Text)

Formatting

No special formatting is needed, the result will be shown as a number between 1 and 255.

Example

See the example for FREQUENCY.

Subscribe to: Post Comments ( Atom )