Exceljet

Quick, clean, and to the point

Excel CODE Function

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:

http://en.wikipedia.org/wiki/Windows-1252 - Windows

http://en.wikipedia.org/wiki/Mac_OS_Roman - Mac

Related functions 
Excel CHAR function
Excel CHAR Function

The Excel CHAR function returns a character when given a valid character code. CHAR can be used to specify characters that are hard to enter in a formula. For example, CHAR(10) returns a line break on Windows, and CHAR(13) returns a line break on...

Good links 
Microsoft CODE function documentation

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.

500 Formula Examples, thoughtfully explained.