Difference between revisions of "Manuals/calci/CODE"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| − | <div style="font-size:30px">'''CODE( | + | <div style="font-size:30px">'''CODE(string)'''</div><br/> |
| − | *<math> | + | *<math>string</math> is the character for which you want the code.. |
==Description== | ==Description== | ||
| − | *Returns a numeric code for the first character of a | + | *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 | ||
| − | + | |- | |
| + | |- class="odd" | ||
| + | |=CODE("ஸ") | ||
| + | |ஸ | ||
| + | |3000 | ||
| − | =CODE(" | + | |- 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== | ||
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 |