The CODE function returns a numeric code for the first character in a text string. This function is useful for extracting the numeric code of a specific character within a text string, particularly beneficial for tasks involving data manipulation and analysis.



text The text string containing the character for which you want to obtain the numeric code.

About CODE

In the landscape of text manipulation within Excel, the CODE function finds its place as a handy tool for deciphering the numeric representation of characters. Whether you're delving into textual data analysis, data cleansing, or encoding-related tasks, the CODE function provides a swift means to uncover the underlying numeric codes of characters within a given text string. This aids in understanding the underlying encoding of characters, character mapping, and handling of non-printable characters within the textual data set, thereby contributing to efficient data processing and analysis workflows.


Suppose you have the text string 'Hello' and you want to find the numeric code of the first character 'H'. The CODE formula would be: =CODE('H')

Suppose you have a list of text strings representing country codes, such as 'AUS', 'USA', 'JPN', and 'GER', and you want to extract the numeric codes for the first characters of each string. You can use the CODE function in combination with other functions to achieve this task.


What is the purpose of the CODE function in Excel?

The CODE function serves to retrieve the numeric code corresponding to the first character within a given text string. It enables users to obtain the underlying ASCII representation of characters, facilitating tasks related to character mapping, encoding, and data manipulation.

Can the CODE function handle multi-character text strings?

No, the CODE function specifically returns the numeric code for the first character within the provided text string. It does not process multi-character strings or return codes for subsequent characters within the same function call.

In what scenarios would you use the CODE function?

The CODE function finds utility in scenarios involving ASCII character manipulation, text encoding, character mapping, and data cleansing tasks. It is particularly valuable when working with textual data sets, facilitating the understanding and management of the underlying character representations within the data.

Related functions