Excel UNICODE Function (3 Practical Examples)

Excel UNICODE Function

The Excel UNICODE Function returns the number (code point) corresponding to the first character of the text.  The result is a number in decimal notation. For example, =UNICODE(A) returns 65.

Syntax:

UNICODE(text)

Text: The Text character or reference to Text character for which users want the Unicode value.

Example: The following tables gives some examples of UNICODE Function.

Note:

1. If text is more than one characters, the UNICODE returns the Code of the fist character. In our example, =UNICODE(Apple) returns the code of A–65.
2. UNICODE is the opposite of UNICHAR Function, which performs the opposite conversion.
3. If text contains partial surrogates or data types that are not valid, UNICODE returns the #VALUE! error value.

More related readings:

1. MS Office post of UNICODE
2. Excel CONCAT Function
3. Extract first Name in excel (3 practical examples)
4. Extract Middle names (3 practical examples)
5. Excel ARRAYTOTEXT Function
6. Excel CLEAN Function with practical examples
7. Excel CONCAT Function to join text
8. Excel REPLACE Function to replace text
9. Excel TRIM Function with Practical Examples
10. Excel RIGHT Function
11. How to generate tomorrow’s date in Excel