Summary

The Excel CODE function returns the numeric code for the first character in a text string. For example, =CODE("A") returns 65.

CODE is useful when you need to identify a character that is hard to notice, such as a leading space, a line break, or another unexpected symbol. It only looks at the first character, so it is often used as a diagnostic tool rather than a display function.

Syntax

=CODE(text)

text is the string or cell reference you want to inspect. CODE reads only the first character and ignores the rest of the string.

Arguments

• text - [Required] The text string or cell reference whose first character you want to identify.

CODE vs Other Functions

CODE and CHAR work as opposites. CODE gives you the number for a character, and CHAR turns that number back into the character. CLEAN, TRIM, and SUBSTITUTE often appear in the next step, after CODE helps identify the problem.

Using CODE

CODE is often used when a value looks correct on screen but still behaves differently in a lookup or comparison. If the first character is a hidden line break or an extra space, CODE can reveal it.

It is also useful when case matters. Uppercase and lowercase letters have different codes, so CODE can show that "A" and "a" are not treated the same.

• Use CODE when a hidden first character may be causing a problem.
• Use CODE with CHAR and SUBSTITUTE when you need to identify and then remove a specific character.
• Use CODE with MID if the character you need to inspect is not the first one.

Example 1 - Checking a Single Character

This is the direct use of CODE. The first character is converted into its numeric code.

=CODE("A") // 65
=CODE("a") // 97
=CODE("1") // 49

Example 2 - Spotting the Difference Between Cases

Uppercase and lowercase versions of the same letter do not share the same code. That makes CODE useful when a column should follow one case rule.

=CODE("A") // 65
=CODE("a") // 97

Example 3 - Finding a Hidden Character

If a cell begins with an invisible character, CODE can reveal it. A result of 10 often means a line break, and 32 means a regular space.

=CODE(B3)
// If B3 starts with a line break, the result is 10

Example 4 - Comparing Against a Target in Another Cell

CODE can also support simple rules. In this example, the formula checks whether the code of the first character meets a minimum value stored in another cell.

=IF(CODE(B4)>=C4, "Pass", "Fail")

If the character you need is not at the start of the string, combine CODE with MID. For example, =CODE(MID(A1,3,1)) checks the third character instead of the first.

Conclusion Recap

• Summary: CODE returns the code for the first character in a text string.
• Syntax: =CODE(text).
• Key point: CODE checks only the first character unless you pair it with another function like MID.
• Practical usage: Hidden-character checks, case checks, and text diagnostics.
• Best pattern: Use CODE to identify a problem character, then use CHAR and SUBSTITUTE to clean it.