Difference between revisions of "Manuals/calci/CODE"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''CODE'''(Text) where, '''Text''' - is the text for which you want the code of the first charcater. </di...") |
|||
Line 1: | Line 1: | ||
− | <div | + | <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. | ||
Line 29: | Line 17: | ||
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" | ||
Line 67: | Line 42: | ||
| Row3 | | Row3 | ||
| class=" SelectTD ChangeBGColor SelectTD" | | | class=" SelectTD ChangeBGColor SelectTD" | | ||
− | |||
| class=" " | | | class=" " | | ||
| class=" " | | | class=" " | | ||
Line 90: | Line 64: | ||
| class=" " | | | class=" " | | ||
|} | |} | ||
− | |||
− | |||
− |
Revision as of 06:51, 20 November 2013
CODE(text)
- 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. It varies according to Operating environment.
CODE
Lets see an example in (Column1, Row1)
=CODE("S")
It returns 83.
Consider an another example in (Column2,Row3)
=CODE("~") CODE returns 126.
Column1 | Column2 | Column3 | Column4 | |
Row1 | 83 | |||
Row2 | 126 | |||
Row3 | ||||
Row4 | ||||
Row5 | ||||
Row6 |