UNICODE function

UNICODE is a new function introduced in Excel 2013.

This function is used to return the code number of the first character of the text in reference.



where text is the character string for which you need the unicode value of first character.

For example, UNICODE(“a”) will return 97 which is the unicode value of character “a” and it will be same result for UNICODE(“apple”) i.e, output as 97 since this function returns the unicode value of first character which is “a” in both the cases.


Note: If the text in reference is an invalid data type, UNICODE function will return #VALUE! error.


Returns the   number (code point) that corresponds to the first character of the text

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube