この関数は Google スプレッドシートでも 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.