The UNICHAR function returns the Unicode character at a given code point, provided as a number. 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 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, and can be used to add a line break to text in...
The Excel UNICODE function returns a number (code point) corresponding to a Unicode character. Unicode is computing standard for the unified encoding, representation, and handling of text in most of the world's writing systems.