The UNICHAR function in Microsoft Excel and Google Sheets returns the character corresponding to a specific Unicode code point. This function generates a single character text string for a given Unicode code point, which is useful for specifying linguistic characters, special symbols, or mathematical signs.

UNICHAR Function Syntax

The basic syntax of the UNICHAR function is structured as follows:

UNICHAR(number)

• number: A numeric value representing the Unicode code point. The character corresponding to this value will be returned.

For instance,

=UNICHAR(65)

This formula returns the character “A”, which has a Unicode value of 65.

Another example:

=UNICHAR(9731)

This usage produces the snowflake symbol “❅”.

Practical Usage Scenarios

The UNICHAR function can be utilized in numerous practical scenarios. Here are two examples:

Adding Special Symbols

When you want to enhance a data table in Excel or Google Sheets with special icons or symbols, the UNICHAR function proves to be extremely beneficial.

• For example, if you are creating a weather report and want to add weather condition icons for each day such as sun, cloud, and rain, you can use appropriate Unicode symbols:

Returning Character Codes in a Sequence

If you wish to return the Unicode code for each character in a string of text, you can utilize the UNICHAR function in conjunction with ARRAYFORMULA or a loop for batch processing.

=ARRAYFORMULA(UNICHAR({65, 66, 67, 68}))

This function returns the characters “A”, “B”, “C”, “D” respectively.

Such various uses make the UNICHAR function a very useful tool in Excel and Google Sheets, especially for meeting diverse language and symbol requirements. The flexibility provided by this function can make data presentation more comprehensible and visually appealing.

Daha fazla bilgi: https://support.microsoft.com/tr-tr/office/unicodekarakterİ-işlevi-ffeb64f5-f131-44c6-b332-5cd72f0659b8