What is CHAR?
Returns the character specified by a code number. Convert ASCII/Unicode codes to characters.
Syntax
=CHAR(number)
Example
Formula: =CHAR(65)
Result: A
How It Works
Returns character for the code. CHAR(65)='A', CHAR(10)=line break, CHAR(9)=tab. Useful for inserting special characters.