EXCEL CODE FUNCTION

The ANSI value of a single character or the first character in a string is returned by this function. Windows uses the ANSI character set to identify each keyboard character with a unique number. The ANSI set has 255 characters. For instance, the ANSI code for letter A is 65, the ANSI code for letter B is 66, and the ANSI code for letter C is 97.

Syntax:

=CODE (text)

Parameter list:

  • text – the text for which a number coding is desired.

Step By Step Guide of CODE Function

Example :

when we gives =Code(A2), here A2 contains “A” letter in it, returns 65 as result and so on.

Related Functions

HLOOKUP Function

HLOOKUP Function

Explore Now

VLOOKUP Function

VLOOKUP Function

Explore Now

INDEX Function

INDEX Function

Explore Now

MATCH Function

MATCH Function

Explore Now

DATE Function

DATE Function

Explore Now

IF Function

IF Function

Explore Now

OR Function

OR Function

Explore Now

AND Function

AND Function

Explore Now

RANK Function

RANK Function

Explore Now

SUMIF Function

SUMIF Function

Explore Now

XIRR Function

XIRR Function

Explore Now

WORKDAYS Function

WORKDAYS Function

Explore Now