writer
5,435
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + + − '''CODE'''(Text)+ + − where,+ − − '''Text''' - is the text for which you want the code of the first charcater. − − </div> − ---- − <div id="1SpaceContent" class="zcontent" align="left">Returns a numeric code for the first charcter in a text string.</div> − ---- − <div id="7SpaceContent" class="zcontent" align="left">It varies according to Operating environment.</div> − ---- − <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left"> − CODE − </div></div> − ---- − <div id="8SpaceContent" class="zcontent" align="left"> − <nowiki>=CODE("S")</nowiki>+ Line 29:
Line 17: − <nowiki>=CODE("~")</nowiki>+ − − − </div> − ---- − <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div> − ---- − <div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div> − ---- − <div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div> − ---- − <div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div> − ---- − <div id="2SpaceContent" class="zcontent" align="left"> Line 67:
Line 42: − <div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]] </div> Line 90:
Line 64: − − <div align="left">[[Image:calci1.gif]]</div></div> − ----
no edit summary
<div id="6SpaceContent" class="zcontent" align="left">
<div style="font-size:30px">'''CODE(text)'''</div><br/>
*<math>Text</math> is the text for which you want the ASCII code of the first character.
Returns a numeric code for the first charcter in a text string.</div>
It varies according to Operating environment.</div>
CODE
Lets see an example in (Column1, Row1)
Lets see an example in (Column1, Row1)
=CODE("S")
It returns 83.
It returns 83.
Consider an another example in (Column2,Row3)
Consider an another example in (Column2,Row3)
=CODE("~")
CODE returns 126.
CODE returns 126.
{| id="TABLE3" class="SpreadSheet blue"
{| id="TABLE3" class="SpreadSheet blue"
| Row3
| Row3
| class=" SelectTD ChangeBGColor SelectTD" |
| class=" SelectTD ChangeBGColor SelectTD" |
| class=" " |
| class=" " |
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|}
|}