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
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...
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...
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 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.
