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