The CODE Function is to convert the first character of a text string into a numeric value.
Formula:
= CODE(text)
Explanations:
– Text is required; where the first character you need to translate into a numeric value.
Cautions:
– The returned numeric values might be different according to the character set in your computer.
Example: What are the numeric values for character A and B?
=CODE ("A"), returns to the numeric value of 65;
=CODE ("B"), returns to the numeric value of 66.