ARTICLE

Unicode Function in Excel 2013

Posted by Megha Goyal Articles | Office 2013 September 19, 2012
In this article we will discuss how to use the Unicode function in Excel 2013.
Reader Level:

This is a new function introduced in Excel 2013. This function is used to return a corresponding Unicode value of the text given as an argument to this function. The syntax of this method is as follows: Unicode(Text) where Text is the argument of which we want to determine the corresponding Unicode value.

Let's have a look at the following steps.

Step 1

First go to Excel 2013.

Step 2

Now open a blank Excel workbook template out of the available templates.

Unicode-in-Excel2013.jpg

Step 3

Now write the following text of which we want to determine the Unicode value.

Excel2013-Unicode-function.jpg

In the above figure the blank cell has a space character of which we want to determine the Unicode value.

Step 4

Now write the following formula to find the Unicode value of the corresponding argument given to it.

Use-of-unicode-function-in-Excel2013.jpg

Step 5

The output will be like this:

Unicode-function-in-excel2013.jpg

Login to add your contents and source code to this article
post comment
     
COMMENT USING
PREMIUM SPONSORS
Over-C is a holistic consortium of communications and technology specialists. We build, deploy and market both business as well as consumer products and solutions.
Join a Chapter
SPONSORED BY
  • PDF reports have never been easier to create. With our included WYSIWYG Designer, you can layout your reports, set up your data source and let DynamicPDF ReportWriter do the rest.
Get Career Advice from Experts