Sunday 12 March 2017

Excel - Excel Code Function

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 : 

CODE( text ) 

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

No comments:

Post a Comment