Learn How to Use Microsoft Excel UNICHAR Function - Done
In this article, you will learn how to use the MS Excel UNICHAR function and its prime function in Microsoft Excel. You will also get to know the Microsoft Excel UNICHAR function return value and syntax with the help of some examples.
Microsoft Excel UNICHAR Function
The primary function of the Microsoft Excel UNICHAR character is to get a Unicode character by a number. That means with the help of the UNICHAR function; you can able to return a Unicode character based on a given number.
UNICHAR Function Return Value
It will return the Unicode character.
UNICHAR Function Syntax
Where the argument:
- number: It is the code point for a Unicode character in decimal.
How to Use the Microsoft Excel UNICHAR Function?
As we know, the UNICHAR function is used to return a Unicode character from a given code point, provided as a decimal value. Unicode is the computer standard used for the unified coding, text-handling, and representation in most of the world's writing systems.
Let us understand the UNICHAR function with the help of the example given below:
Example 1: The Euro Symbol has code point 8364 in the decimal notation, the formula used below will return the Euro character:
= UNICHAR(8364) - It will return the Euro sign.
Check out the list of all other articles:
- Learn How to Get nth Match in Microsoft Excel
- Learn How to Find Missing Values in Microsoft Excel
- Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
- Learn How to Sort by Text Length in Microsoft Excel
- Learn How to Sort by Two Columns in Microsoft Excel
- Learn How to Sort by Random in Microsoft Excel
- Learn How to Sort by One Column in Microsoft Excel
- Learn How to Sort by Custom List in Microsoft Excel