writer
5,435
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + − + + + + + Line 18:
Line 22: + + + + + − Lets see an example in (Column1, Row1)+ + + + + − + + + + − It returns 83.+ + + + − Consider an another example in (Column2,Row3)+ + + + − + − CODE returns 126.+ + + + +
no edit summary
<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"
==Examples==
==Examples==
{| id="TABLE3" class="SpreadSheet blue"
|- class="even"
! =CODE("string")
! string
! Result
|-
|- class="odd"
|=CODE("ஸ")
|ஸ
|3000
=CODE("S")
|- class="even"
|=CODE("string")
|d
|100
|- class="odd"
|=CODE(":")
|:
|58
|- class="even"
|=CODE("Y")
|Y
|89
=CODE("~")
|- class="odd"
|=CODE("!")
|!
|33
|}
==See also==
==See also==