CHAR
Returns the character specified by a number. Use CHAR to translate code page numbers you might get from files on other types of computers into characters.
Syntax
CHAR(number)
Number is a number between 1 and 255 specifying which character you want. The character is from the character set used by your computer.
Example
| Formula | Description (Result) |
|---|---|
| =CHAR(65) | Displays the 65 character in the set (A) |
| =CHAR(33) | Displays the 33 character in the set (!) |