UNICODE
Definition: The UNICODE function in Excel is used to return the Unicode code of a character.
Syntax: ==UNICODE(text).
Situation: This formula is appropriate in situations where you need to return the Unicode code of a character.
Example: If you have a cell that contains the letter “A”, you would use the formula =UNICODE(“A”). This would return the value 65, which is the Unicode code for the letter “A”.