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, which is new in Excel 2016. You can use this approach to create initials from names, or to create acronyms...
Related videos
A short introduction to the CODE and CHAR functions, two geeky (but surprisingly useful) functions that help you manipulate text in Excel.
Related functions
Good links
