Excel CODE Function
Summary
The Excel CODE function returns a numeric code for a given character. For example, CODE("a") returns the code 97. The CODE function can be used to figure out numeric codes supplied to the CHAR function.
Purpose
Get the code for a character
Return value
A numeric code representing a character.
Syntax
=CODE (text)
Arguments
- text - The text for which you want a numeric code.
Usage notes
CODE returns a numeric code for the first character in a text string. The code is based on the character set used by your computer.
Links:
CODE formula examples
To remove specific unwanted characters in Excel, you can use a formula based on the substitute function.
In the example shown, the formula in C4 is:
=SUBSTITUTE(B4,CHAR(202),"")
Which removes a series of 4...
To abbreviate text that contains capital letters, you can try this array formula based on the TEXTJOIN function, a new function available in Office 365 and Excel 2019. You can use this approach to create initials from...
Related videos
Each character you see displayed in Excel has a number. In this video, we look at two functions that work with these numbers directly: CODE and CHAR.
Related functions
