CODE
Converting Between Characters & Numeric Codes
Basic Description
The Excel Code function converts the first character of a supplied text string into the associated numeric character set code used by your computer.
- note that this code may vary across different computer systems.
The syntax of the Code function is :
Where the text argument is a text string, which is supplied to the function either directly or as a reference to a cell containing a string.
Code Function Examples
The following spreadsheet shows examples of the Excel Code function used to return the numeric code for a number of different text strings.
The format of the function is shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right - Note that these results are from the Ansi character set (used on the Windows operating system).
Formulas:
|
Results:
|