The CODE function, an Excel Text function returns a numeric code for the first character of a text string. The returned numeric code is based on the character set used by the operating system of the computer. Windows operating systems use the ASCII or ANSI character set.
In this above image a general overview of the Excel CODE function is given. Throughout the article, we will learn more details and different applications of the function.
📂 Download Practice Workbook
Introduction to The CODE Function
❑ Objective
Excel CODE function 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
Argument | Required/Optional | Explanation |
---|---|---|
text | Required | Any text string, a code will be returned for the first character of the text string |
❑ Output
A numeric number will be returned for the first character of the input text string. In general, the number returned by CODE represents the ASCII decimal code for a character. The CODE function was developed to operate in an ASCII/ANSI domain, and it only knows how to map characters to integers 0-255.
❑ Version
It was introduced in Excel 2000 and is available in all versions after that.
5 Examples of Using The CODE Function in Excel
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),
=CODE(B6)
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 C6 to the end of your dataset.
If you notice, you will see that uppercase and lowercase of the same alphabet have different codes.
Read More: How to Use TEXT Function to Format Codes in Excel
2. ANSI Code of Numerical Digits and Symbols
You can also get ANSI codes of different numerical digits and symbols using the CODE function. Suppose in this time you have a list of different digits and mathematical signs in your dataset. To get the code of these characters,
➤ Type the following formula in cell C6,
=CODE(B6)
The formula will return the code in cell C6 of the character of cell B6.
After that,
➤ Press ENTER and drag cell C6 to the end of your dataset.
As a result, you will get the codes for all of the numerical digits and signs of your dataset.
Remember that, the CODE function only returns the code of the first character of the input text strings. So, if the input number, text, or sign has multiple digits or characters the function will return a code only for the first digit or character. You will get a clear idea of that from the next image.
Read More: How to Auto Generate Number Sequence in Excel (9 Examples)
Similar Readings
- How to use SUBSTITUTE function in Excel (4 Examples)
- Use SEARCH Function in Excel (3 Examples)
- How to use PROPER function in Excel (2 Examples)
- Use TEXT Function in Excel (10 Examples)
- How to Use RIGHT Function in Excel (6 Examples)
3. CODE Function for Word or Sentence
For a word or sentence, the CODE function will return the code of the first character of the word or sentence. Let’s say, you have a dataset where you have a list of words and sentences. Now,
➤ Type the following formula in an empty cell C6,
=CODE(B6)
The formula will return the code for the first character of cell B6 in cell C6.
After that,
➤ Press ENTER
As a result, you will get the code of the first character of the text of cell B6 in cell C6.
At last,
➤ Drag cell C6 to the end of your dataset to get the code of the first character of all of the words or sentences of your dataset.
4. CODE Function with Other Functions
You can use the CODE function with other functions to get different desired results. Suppose you want to get the code for the uppercase of the text of cell B6. In this, you can use the UPPER function with the CODE function to get your desired result.
➤ Type the following formula,
=CODE(UPPER(B6))
Here, the UPPER function will convert the text of B6 into uppercased and then the CODE function will return the code for the first character of the converted text.
➤ Press ENTER
As a result, you will get the code for the uppercase of the first character of the input text.
In a similar way, you can use other functions with the CODE function based on your needs. In the image below I’ve shown some such examples.
Read More: How to Use LOWER Function in Excel (5 Suitable Examples)
5. Text Input in The CODE Function
Instead of referring to a cell, you can input the text directly in the CODE function, though the text must be inserted between double quotation marks. To get the code for the alphabet A,
➤ Type the following formula
=CODE("A")
Here, the formula will give a code for the alphabet between the double quotation marks.
➤ Press ENTER and you’ll get the code for A
In a similar way, you can get the code for the first character of a text, number, or symbol.
Remember that at this time you need to insert the formula for all of the texts separately. You can’t drag the formula cell to apply the formula for other inputs when you are inserting the text directly into a formula.
Read More: How to Combine Text and Numbers in Excel and Keep Formatting
💡 Things to Remember When Using The CODE Function
📌 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 characters of ASCII. If you need the code of any other characters you can use the UNICODE function.
Conclusion
I hope now you know the basics of the Excel CODE function and will be able to use the function for your needs. If you have any confusion, feel free to leave a comment.
Related Articles
- How to Show Grand Total in Pivot Table (3 Easy Methods)
- Show Percentage in Legend in Excel Pie Chart (with Easy Steps)
- How to Use Format Function in Excel (with Suitable Examples)
- Use FIXED Function in Excel (6 Suitable Examples)
- How to Use Excel EXACT Function (6 Suitable Examples)
- Use CLEAN Function in Excel (10 Examples)
- How to use TRIM function in Excel (7 Examples)