Difference between revisions of "Manuals/calci/CHAR"
Jump to navigation
Jump to search
| Line 16: | Line 16: | ||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | ! CHAR( | + | ! CHAR(nb) |
| − | ! | + | ! nb |
! Result | ! Result | ||
|- | |- | ||
|- class="odd" | |- class="odd" | ||
| − | |CHAR( | + | |CHAR(nb) |
|3000 | |3000 | ||
|ஸ | |ஸ | ||
|- class="even" | |- class="even" | ||
| − | |CHAR( | + | |CHAR(nb) |
|100 | |100 | ||
|d | |d | ||
Revision as of 00:01, 20 November 2013
CHAR(nb)
- where is the number from 1 to infinity.
is the number from 1 to infinity.Description
- This function gives the ANSI characters for given Number.
- CHAR()gives a specific character for a number.
- Also the number is between 1 to infinity.
- The can be a number directly or indirectly like cell reference.
- The character is from the character set used in our system.
- CHAR(65)
- CHAR(B5), where B5 is the cell number
- CHAR(100)
Examples
| CHAR(nb) | nb | Result |
|---|---|---|
| CHAR(nb) | 3000 | ஸ |
| CHAR(nb) | 100 | d |
| CHAR(nb) | 58 | : |
| CHAR(nb) | 89 | Y |
| CHAR(nb) | 33 | ! |