| Line 1: |
Line 1: |
| − | <div style="font-size:30px">'''CHAR(nb)'''</div><br/> | + | <div style="font-size:30px">'''CHAR(Nb)'''</div><br/> |
| | | | |
| − | *where Nb is the number from 1 to 255. | + | *where Nb is the number from 1 to infinity. |
| | | | |
| | ==Description== | | ==Description== |
| − | *This function gives the ANSI chracters for given Number. | + | *This function gives the ANSI characters for given Number. |
| − | *Function CHAR is used to give the spcific character for the number. | + | *CHAR()gives a specific character for a number. |
| − | *Also the number is between 1 to 255.The Nb can be a number directly or indirectly like cell reference. | + | *Also the number is between 1 to infinity. |
| − | *The character is from the character set using in our system. | + | *The Nb can be a number directly or indirectly like cell reference. |
| | + | *The character is from the character set used in our system. |
| | | | |
| − | **<math>=COMPLEX(5,2)</math> gives <math>5+2i</math> | + | **CHAR(65) |
| − | **<math>=COMPLEX(5,2,"j")</math> gives <math>5+2j</math> | + | **CHAR(B5), where B5 is the cell number |
| | + | **CHAR(100) |
| | | | |
| | ==Examples== | | ==Examples== |