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.
Examples
| Formula |
Description (Result) |
| =CHAR(65) |
Displays the 65 character in the set (A) |
| =CHAR(33) |
Displays the 33 character in the set (!) |