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.
Version
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
The SUBSTITUTE function can find and replace text in a cell, wherever it occurs. In this case, we are using SUBSTITUTE to find a character with code number 202, and replace it with an empty string (""), which...
Working from the inside out, the MID function is used to cast the string into an array of individual letters:
MID(B5,ROW(INDIRECT("1:"&LEN(B5))),1)
In this part of the formula, MID, ROW, INDIRECT, and...
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
Download 100+ Important Excel Functions
Get over 100 Excel Functions you should know in one handy PDF.
