Exceljet

Quick, clean, and to the point

Excel UNICODE Function

Excel UNICODE function
Summary 

The Excel UNICODE function returns a number (code point) corresponding to a Unicode character in decimal format. Unicode is computing standard for the unified encoding, representation, and handling of text in most of the world's writing systems. 

Like ASCII, Unicode is a character set. However, Unicode is a very large character set, because Unicode is a superset of other character sets. Whereas ASCII contains 128 characters, Unicode 11.0 (June 2018) contains 137,439 characters covering 146 modern and historic scripts.

Unicode can be implemented in different encodings, for example UTF-8, UTF-16, etc. UTF-8 dominates the web. It is estimated that over 90% of websites use UTF-8. The first 128 Unicode code points are the ASCII characters.

Example

The Euro symbol (€) is code point 8364 in decimal notation, so the following formula returns 8364:

=UNICODE() // returns 8364

With the Euro symbol in cell A1, the formula below has the same result:

=UNICODE(A1) // returns 8364

Note: the UNICHAR function performs the opposite conversion, returning the Unicode character at a given code point.

Purpose 
Get number from Unicode character
Return value 
Unicode code point in decimal
Syntax 
=UNICODE (text)
Arguments 
  • text - Unicode character to convert to number.
Usage notes 

The Excel UNICODE function returns the number (code point) that corresponds to the first character of the text. Unicode is computing standard for the unified encoding, representation, and handling of text in most of the world's writing systems. 

Like ASCII, Unicode is a character set. However, Unicode is a very large character set, because Unicode is a superset of other character sets. Whereas ASCII contains 128 characters, Unicode 11.0 (June 2018) contains 137,439 characters covering 146 modern and historic scripts.

Unicode can be implemented in different encodings, for example UTF-8, UTF-16, etc. UTF-8 dominates the web. It is estimated that over 90% of websites use UTF-8. The first 128 Unicode code points are the ASCII characters.

Example

The Euro symbol (€) is code point 8364 in decimal notation. The following formula will return the Euro character:

=UNICHAR(8364) // returns euro sign

Note: the UNICODE function performs the opposite conversion, returning the code point for a given Unicode character.

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.