The Excel CODE Function

Home » Excel-Built-In-Functions » Excel-Code-Function

Search this site:

Custom Search

Related Function :

CHAR Function

Character Encoding

The character encoding used by your computer will depend on the operating system used - Windows uses the ANSI character set, whereas Macintosh uses the Macintosh character set.

Therefore, the numeric codes returned by the Excel Code Function may be different for different operating environments.

Basic Description

The Excel CODE function converts the first character of a supplied text string into the associated numeric code used by your computer.

- note that this code may vary across different computer systems.

The format of the Code function is :

CODE( Text )

where the Text argument is a text string, which is supplied to the function either directly or as a reference to a cell containing a string.

Examples

The following spreadsheet shows examples of the Excel Code function used to return the numeric code for a number of different text strings. The format of the function is shown in the spreadsheet on the left and the result is shown in the spreadsheet on the right - Note that these results are from the Ansi character set (used on the Windows operating system).

Formulas
Examples of use of the Excel Code Function