Difference between revisions of "Manuals/calci/CODE"

From ZCubes Wiki
Jump to navigation Jump to search
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==

Revision as of 23:09, 20 November 2013

CODE(string)


  • is the character for which you want the code..

Description

  • CODE()gives a specific CODE for the string entered.
  • The can be of any length in which first character will be taken.
  • The 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.
Operating Character Set
Windows ANSI
Macintosh Macintosh Character Set

Examples

=CODE("string") string Result
=CODE("ஸ") 3000
=CODE("string") d 100
=CODE(":") : 58
=CODE("Y") Y 89
=CODE("!") ! 33

See also

References

SUM