Returns the Unicode character that corresponds to the numeric value provided.
Cette fonction fonctionne de la même façon dans Google Sheets que dans Excel — même syntaxe et mêmes arguments.
UNICHAR(number)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)Résultat : A
Returns the character corresponding to the Unicode value 65.
=UNICHAR(9731)Résultat : ☃
Returns the snowman symbol associated with the Unicode value 9731.
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.