Returns the Unicode character that corresponds to the numeric value provided.
Syntaxe
UNICHAR(number)Arguments
numberobligatoire
The Unicode number that represents the character you want to return.
The UNICHAR function converts a numeric Unicode code point into its corresponding character. This function is the inverse of the UNICODE function and is useful for generating special symbols or characters that are not easily typed on a standard keyboard.
=UNICHAR(65)→AReturns the character corresponding to the Unicode value 65.
=UNICHAR(9731)→☃Returns the snowman symbol associated with the Unicode value 9731.
Select a cell
Click on the cell where you want to display the Unicode character.
Enter the formula
Type =UNICHAR(number) and replace 'number' with the desired Unicode code point.
Press Enter
Press Enter to see the character generated in the cell.
CHAR is limited to the ANSI character set (0-255), while UNICHAR supports the full Unicode range, allowing for a much wider variety of symbols and international characters.