How to Use CODE Function

The CODE Function is to convert the first character of a text string into a numeric value.


= CODE(text)


– Text is required; where the first character you need to translate into a numeric value.


– 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.

Download: Code Function

Leave a Reply