CODE Function (Functions in Excel)
Letter | ANSI Code | |
A | 65 | =CODE(C4) |
B | 66 | =CODE(C5) |
C | 67 | =CODE(C6) |
a | 97 | =CODE(C7) |
b | 98 | =CODE(C8) |
c | 99 | =CODE(C9) |
Alan | 65 | =CODE(C10) |
Bob | 66 | =CODE(C11) |
Carol | 67 | =CODE(C12) |
What Does It Do? |
This function shows the ANSI value of a single character, or the first character in a piece |
of text. |
The ANSI character set is used by Windows to identify each keyboard character by using |
a unique number. |
There are 255 characters in the ANSI set. |
Syntax |
=CODE(Text) |
Formatting |
No special formatting is needed, the result will be shown as a number between 1 and 255. |
Example |
See the example for FREQUENCY. |
0 comments:
Post a Comment