CODE

Returns the Unicode value of a character.

Syntax

CODE(character)

• character - the character from which the Unicode value is to be returned - Value type: text

Remarks

• If character is a text with several characters, only the Unicode value of the first character is returned.

Examples

CODE with a single character:

CODE with multiple characters:

In combination with the CSVTORANGE function, you can determine all the Unicode values of a text.

In this case, the text mytext is first split into its individual letters using the CSVTORANGE function. The CODE function can then be applied to the individual cells.