❑ Objective Excel CODEfunction returns a numeric code for the first character in a text string, in the character set used by your computer. ❑ Syntax CODE(text) ❑ Argument Explanation ❑ Output A numeric number will be returned for the first character of the input text string. In general, the number returned byCODE represents the ASCII decimal code f...

1. Get The ANSI Code of Alphabet
You can use the CODE function to get the ANSI code for different alphabets. Suppose you have different alphabets in a list of your Excel dataset and you want to know the corresponding code. ➤ Type the following formula in an empty cell (C6), The formula will return the code of the alphabet of cell B6, ➤ Press ENTER and you’ll get the code in cell C6 of the alphabet of cell B6. To get the code of all of the alphabets of your dataset, ➤ Drag cell C6to the end of your dataset. If you notice, you...

📌 When the text arguments left empty, the formula shows #VALUE! Error. 📌 The CODE function is inverse of the CHAR function. The CHAR function gives the character of the corresponding code. 📌 You may get a different output if you use any other operating system such as Linux or macOS. 📌 The CODE function only returns code for specific 255 charact...