Returns the character specified by the code number.
פונקציה זו פועלת ב-Google Sheets בדיוק כמו ב-Excel — אותה תחביר ואותם ארגומנטים.
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)תוצאה: A
Returns the uppercase letter A, which corresponds to the ASCII code 65.
=CHAR(10)תוצאה: 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.