UNICODE Function

Returns the code point for the first character of a supplied text string

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:

  1. 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:

UNICODE Function

In the adjacent column, we will enter the following formula:

 

UNICODE Function - Example 1

We get the results below:

UNICODE Function - Example 2

  1. 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.
  2. When we gave Beta, the UNICODE function returned the code point for the character “B” (UPPERCASE). The result is 66.
  3. 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:

UNICODE Function - Example 2

We got a #VALUE! error because we gave an unidentified number in row 8.

Few pointers about the UNICODE Function

  1. #VALUE! error – Occurs when:
    • Unicode numbers are partial surrogates and data types are not valid.
    • Unicode numbers fall outside the range allowed.
  2. The UNICODE function is the opposite of the UNICHAR function.

Click here to download the sample Excel file

Additional Resources

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:

Article Sources

  1. UNICODE Function

Excel Tutorial

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.

Launch CFI’s Excel Course now

to take your career to the next level and move up the ladder!

0 search results for ‘