How to use the UNICODE Function in Excel

Description

The UNICODE Function is categorized as Text Function in Excel. This function returns a numeric code (code point) for the first character of the given text. Unicode is computing standard for the unified encoding, representation, and handling of text in most of the world's writing systems.

The UNICODE function takes one argument which can be a text string or any cell reference or a number. It can also be used as a part of a formula.

Syntax

The syntax of UNICODE function is =UNICODE(text)

Argument or Parameter

text (Required)- can be a text string or cell reference or a number for which we want the code of first character.

Returns

The UNICODE returns a numeric code (code point) of the first character of the given text or number.

Example

Example-1

In the example given below, we can see in column A we have uppercase letters and in column D we have lowercase letters and right side of each column we the character code of each letter. Here we used UNICODE function to get the code of single letter. See the image below.

Example-2

In this example, we have used single and multiple word text to get the numeric code of the first character of the text string. In column A, we have the the words and in column B we have the numeric code returned by the UNICODE function. You can compare this example with the first example, you will get that function returns the same code if the first character is same.

Example-3

In this example, we have used some special characters to the numeric code.

Notes

It returns the numeric code of the first character of the given text.
It return #Value, if argument left blank.
UNICHAR function does the opposite of CODE.
Text argument to the function can be given as cell reference and directly using the quotation marks.

********************************* ~:Support Our Work Financially:~ *********************************

Project File Type: Free

If you think this tutorial helps you to solve your problem and add value to your work, Buy me a Coffee..

************************************************************************************************

TEXT FUNCTIONS FUNCTIONS
BAHTTEXT	CHAR	CLEAN	CODE	CONCATENATE
DOLLAR	EXACT	FIND	FIXED	LEFT
LEN	LOWER	MID	NUMBERVALUE	PROPER
REPLACE	REPT	RIGHT	SEARCH	SUBSTITUTE
T	TEXT	TRIM	UNICHAR	UNICODE
UPPER	VALUE