Difference between revisions of "Manuals/calci/CHAR"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| − | <div style="font-size:30px">'''CHAR( | + | <div style="font-size:30px">'''CHAR(nb)'''</div><br/> |
| − | *where <math> | + | *where <math>nb</math> is the number from 1 to infinity. |
==Description== | ==Description== | ||
| Line 7: | Line 7: | ||
*CHAR()gives a specific character for a number. | *CHAR()gives a specific character for a number. | ||
*Also the number is between 1 to infinity. | *Also the number is between 1 to infinity. | ||
| − | *The <math> | + | *The <math>nb</math> can be a number directly or indirectly like cell reference. |
*The character is from the character set used in our system. | *The character is from the character set used in our system. | ||
**CHAR(65) | **CHAR(65) | ||
| Line 32: | Line 32: | ||
|- class="odd" | |- class="odd" | ||
| − | | CHAR( | + | | CHAR(nb) |
|58 | |58 | ||
|: | |: | ||
|- class="even" | |- class="even" | ||
| − | | CHAR( | + | | CHAR(nb) |
|89 | |89 | ||
|Y | |Y | ||
|- class="odd" | |- class="odd" | ||
| − | |CHAR( | + | |CHAR(nb) |
|33 | |33 | ||
|! | |! | ||
Revision as of 06:24, 19 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 | ! |