The Excel UNICHAR function returns a Unicode character based on a given number.
Get Unicode character by number
number - Code point for a Unicode character in decimal.
The UNICHAR function returns the Unicode character at a given code point, provided as a decimal value. 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.
The Euro symbol (€) is code point 8364 in decimal notation. The following formula will return the Euro character:
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...
The Excel CODE function returns a numeric code for a given character. For example, CODE("a") returns the code 97. The CODE function can be used to figure out numeric codes supplied to the CHAR function.
The Excel CHAR function returns a character when given a valid character code. CHAR can be used to specify characters that are hard to enter in a formula. For example, CHAR(10) returns a line break on Windows, and CHAR(13) returns a line break on...
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.