UNICODE(text)

Returns the UNICODE number for the first character in a text string.

textThe text string you want to use.

Remarks

* Added in Excel 2013.
* This function is useful when you want to specify characters that are difficult or impossible to type directly.
* You can use the UNICHAR function to return the character with the corresponding UNICODE number.
* You can use the CODE function to return the ANSI/ASCII number for the first character in a text string.
* You can use the CHAR function to return the character with the corrresponding ANSI/ASCII character.
* For more information about the different character sets refer to the Character Codes page.
* For the Microsoft documentation refer to support.office.com

 A
1=UNICODE("A") = 65
2=UNICODE("B") = 66
3=UNICODE("C") = 67
4=UNICODE("a") = 97
5=UNICODE("b") = 98
6=UNICODE("Alphabet") = 65
7=UNICODE(-1) = 45
8=UNICODE(UNICHAR(23)) = 23
9=UNICODE("some text") = 115
10=UNICODE("") = #VALUE!


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top