Returns a numeric code for the first character in a text string.
Syntaxis
CODE(text)Argumenten
textvereist
The text for which you want the code of the first character.
The CODE function returns the character code corresponding to the first character of a text string. The returned code is based on the character set used by your computer, typically ASCII or Unicode.
=CODE("A")→65Returns the ASCII code for the uppercase letter A.
=CODE("Excel")→69Returns the code for the first character 'E'.
Select a cell
Click on the cell where you want to display the result.
Enter the formula
Type =CODE(text) and replace 'text' with the string or a cell reference.
It returns a #VALUE! error.