Returns a numeric code for the first character in a text string. The returned code corresponds to the character set used by your computer.

Syntax

CODE(text)

Text     is the text for which you want the code of the first character in the text string.

Examples

Formula

Description (Result)

=CODE("A")

Displays the numeric code for A (65)

=CODE("!")

Displays the numeric code for ! (33)

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.