UNICHAR

The UNICHAR function in Google Sheets returns the Unicode character for a number. This function is useful when you want to display special characters or symbols in your spreadsheet.

Function Syntax and Parameters

Syntax: UNICHAR(number)

Parameters:

• number: The Unicode number for the character you want to display.

Step-by-Step Tutorial

1. Using UNICHAR with a Unicode number:

   • Example: =UNICHAR(65)
   • Result: A

2. Using UNICHAR with a cell reference:

   • Example: If cell A1 contains the Unicode number 8364, then =UNICHAR(A1) will display the Euro symbol (€).

Use Cases and Scenarios

1. Displaying Symbols and Special Characters: Use UNICHAR to show symbols, emojis, or special characters in your spreadsheet.
2. Language Support: Utilize UNICHAR to display characters from different languages or writing systems.

Related Functions

• None

Related Articles

• None