CHAR

Definition: CHAR is a function that returns the character specified by a number.

Syntax: =CHAR(number)

Situation: This formula is suitable when you need to convert a number to its corresponding character, such as converting ASCII codes to letters.

Example: If you have a number 65, which corresponds to the letter “A” in ASCII code, the character can be found using the formula =CHAR(65), which returns “A”.