Excel CODE Function
The Excel CODE function, which is categorized as Text Function, returns a numeric code for the first character in a text string. For example, =CODE(“A”) returns the value of 65. The returned code corresponds to the character set used by users’ computer. The Excel CODE Function returns ANSI characters for Windows operating system. It is the opposite of CHAR function.
List of examples:
- How to generate ANSI value of English letters?
- How to generate the ANSI code the first letter of a word?
- How to use LOWER function with CODE to generate ANSI code for lower case letters?
- How to use UPPER function with CODE to generate ANSI code for UPPER case letters?
- How to SUM ANSI codes of different letters?
- How to reverse the ANSI code to character?
Syntax
CODE (text)
where,
text : is the text or the cell reference of the text for which users want the code of the first characters. This is the only argument and it is required.
Example 1: Generate ANSI value English letters:
Answer: The formula is =CODE(C6), which returns the code for the letter A.
Example 2: Generate the ANSI code of the first letter of a word:
Answer: The formula is =CODE(C9) as it is above in example 1.
Example 3: LOWER function with CODE:
Answer: To generate the ANSI code for the letter, which is originally in upper case, users need to combine LOWER and CODE, and the formula is =CODE(LOWER(6)), which returns lowercase A.
Example 4: UPPER function with CODE:
Answer: Users can use the combination of UPPER and CODE as it is in example 3. The example code is =CODE(UPPER(text)).
Example 5: Adding ANSI codes of different letters:
Question: How can I add the ANSI values of different letters? Can I use the combination of SUM and CODE functions to add ANSI values?
Answer: Users can add the ANSI values of different letters by simply using the CODE(text)+CODE(text) formula, numeric values and ANSI values can also be added. The combined formula of SUM and CODE is =SUM(CODE(C9:C12), which returns the sum of the letters’ ANSI values in the range C9:C12.
Example 6: Reverse of ANSI code:
Answer: To reverse the to the character for a given numeric value (between 0-255), Excel CHAR function is used. The formula to convert numeric values to characters is =CHAR(number). Examples to convert numeric values to characters are in the following image.
More related posts:
Thank you for the good writeup. It in fact was a amusement account it. Look advanced to far added agreeable from you! By the way, how could we communicate?
A big thank you for your article.Really thank you! Fantastic.
I have noticed that car insurance companies know the vehicles which are at risk from accidents and various risks. In addition they know what types of cars are given to higher risk as well as the higher risk they have got the higher the particular premium price. Understanding the basic basics with car insurance will let you choose the right style of insurance policy which will take care of your requirements in case you happen to be involved in an accident. Many thanks for sharing your ideas in your blog.
Thanks for the thoughts you have provided here. Also, I believe there are several factors that keep your motor insurance premium lower. One is, to bear in mind buying cars that are inside good set of car insurance firms. Cars which have been expensive tend to be at risk of being snatched. Aside from that insurance policies are also good value of your vehicle, so the more costly it is, then higher the premium you make payment for.
The next time I read a blog, I hope that it doesnt disappoint me as much as this one. I mean, I know it was my option to read, however I really thought youd have one thing interesting to say. All I hear is a bunch of whining about something that you can fix when you werent too busy in search of attention.
You really make it appear so easy with your presentation but I find this matter to be actually something which I believe I might never understand. It kind of feels too complex and extremely huge for me. I am having a look forward for your next submit, I will try to get the dangle of it!