UNICHAR

Definition: The UNICHAR function in Excel is used to return the Unicode character that corresponds to a number.

Syntax: ==UNICHAR(number).

Situation: This formula is appropriate in situations where you need to return the Unicode character that corresponds to a number.

Example: If you have a cell that contains the number 65, you would use the formula =UNICHAR(65). This would return the uppercase letter “A”.