Over 2 million + professionals use CFI to learn accounting, financial analysis, modeling and more. Unlock the essentials of corporate finance with our free resources and get an exclusive sneak peek at the first module of each course.
Start Free
What is the UNICODE Function?
The UNICODE Function[1] is categorized under Excel Text functions. It will give the number (code point) for the first character of a supplied text string. The function was introduced in MS Excel 2013.
Formula
=UNICODE(text)
The UNICODE Function requires the following argument:
Text (required argument) – This is the character or text string for which we need the Unicode character. The text argument can be a single character that is surrounded by double quotation marks (” “) entered directly into the function or a cell reference to the location of the character in a worksheet.
How to use the UNICODE Function in Excel?
To understand the uses of the UNICODE function, let’s look at a few examples:
Example 1
Suppose we are given a set of data that we wish to convert to UNICODE characters. First, we will list down the data in a column, as shown below:
In the adjacent column, we will enter the following formula:
We get the results below:
When we gave Oranges, the UNICODE function returned the code point for the character “O”. It gives the same result for UNICODE (“O”), which is 79.
When we gave Beta, the UNICODE function returned the code point for the character “B” (UPPERCASE). The result is 66.
When we gave beta, the UNICODE function returned the code point for the character “b” (lowercase). The result is 98.
Uppercase vs. Lowercase Letters
Remember that the uppercase or capital letters on the keyboard use different character codes than the corresponding lowercase or small letters.
For example, the UNICODE/ANSI code number for the uppercase “A” is 65 while for the lowercase “a”, the UNICODE/ANSI code number is 97.
Example 2
Let’s now see how the function converts characters. Using UNICODE, we can translate the characters into numbers, as shown below:
We got a #VALUE! error because we gave an unidentified number in row 8.
Few pointers about the UNICODE Function
#VALUE! error – Occurs when:
Unicode numbers are partial surrogates and data types are not valid.
Unicode numbers fall outside the range allowed.
The UNICODE function is the opposite of the UNICHAR function.
Thanks for reading CFI’s guide to important Excel functions. By taking the time to learn and master these functions, you’ll significantly speed up your financial analysis. To learn more, check out these additional CFI resources:
To master the art of Excel, check out CFI’s Excel Crash Course, which teaches you how to become an Excel power user. Learn the most important formulas, functions, and shortcuts to become confident in your financial analysis.
Take your learning and productivity to the next level with our Premium Templates.
Upgrading to a paid membership gives you access to our extensive collection of plug-and-play Templates designed to power your performance—as well as CFI's full course catalog and accredited Certification Programs.
Gain unlimited access to more than 250 productivity Templates, CFI's full course catalog and accredited Certification Programs, hundreds of resources, expert reviews and support, the chance to work with real-world finance and research tools, and more.