Changes

461 bytes added ,  05:09, 21 November 2013
no edit summary
Line 1: Line 1: −
<div style="font-size:30px">'''CODE(text)'''</div><br/>
+
<div style="font-size:30px">'''CODE(string)'''</div><br/>
*<math>text</math> is the character for which you want the ANSI code.
+
*<math>string</math> is the character for which you want the code..
    
==Description==
 
==Description==
*Returns a numeric code for the first character of a text string.
+
*CODE()gives a specific CODE for the string entered.
 +
*The <math>string</math> can be of any length in which first character will be taken.
 +
*The <math>string</math> can be a text directly or indirectly like cell reference.
 +
*The character is from the character set used in our system.
 +
*Returns a numeric code for the first character of a string.
 
*It varies according to Operating environment.
 
*It varies according to Operating environment.
 
{|class="wikitable"
 
{|class="wikitable"
Line 18: Line 22:     
==Examples==
 
==Examples==
 +
{| id="TABLE3" class="SpreadSheet blue"
 +
|- class="even"
 +
! =CODE("string")
 +
! string
 +
! Result
   −
Lets see an example in (Column1, Row1)
+
|-
 +
|- class="odd"
 +
|=CODE("ஸ")
 +
|ஸ
 +
|3000
   −
=CODE("S")
+
|- class="even"
 +
|=CODE("string")
 +
|d
 +
|100
   −
It returns 83.
+
|- class="odd"
 +
|=CODE(":")
 +
|:                                     
 +
|58
   −
Consider an another example in (Column2,Row3)
+
|- class="even"
 +
|=CODE("Y")
 +
|Y
 +
|89
   −
=CODE("~")
+
|- class="odd"
CODE returns 126.
+
|=CODE("!")
 +
|!
 +
|33
 +
 
 +
|}
    
==See also==
 
==See also==
writer
5,435

edits