Returns the character specified by the code number.
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
CHAR(number)The CHAR function converts a numeric code into its corresponding character based on the character set used by your computer. It is commonly used to insert special characters, such as line breaks or symbols, into text strings.
=CHAR(65)Result: A
Returns the uppercase letter A, which corresponds to the ASCII code 65.
=CHAR(10)Result: Line break
Returns the line feed character, often used to force a line break within a cell.
The CHAR function supports numbers from 1 to 255.