Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code for Unicode
Gary,
My Excel help has given up at the moment, so I can't tell if there is something built-in, but these UDFs work : Public Function CodeUnicode(argIn As Variant) As Long CodeUnicode = AscW(argIn) End Function Public Function CharUnicode(argIn As Long) As String CharUnicode = ChrW(argIn) End Function NickHK "Gary''s Student" wrote in message ... If I have a character in a cell, say a in cell A1, then =CODE(A1) will give me the code for this character, in this case 97. What can give me the "code" for a unicode character? (between 1 and 65536) -- Gary's Student |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code for Unicode
Thank you
-- Gary's Student "NickHK" wrote: Gary, My Excel help has given up at the moment, so I can't tell if there is something built-in, but these UDFs work : Public Function CodeUnicode(argIn As Variant) As Long CodeUnicode = AscW(argIn) End Function Public Function CharUnicode(argIn As Long) As String CharUnicode = ChrW(argIn) End Function NickHK "Gary''s Student" wrote in message ... If I have a character in a cell, say a in cell A1, then =CODE(A1) will give me the code for this character, in this case 97. What can give me the "code" for a unicode character? (between 1 and 65536) -- Gary's Student |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unicode entries | Excel Discussion (Misc queries) | |||
Unicode in CSV files | Excel Discussion (Misc queries) | |||
unicode | Excel Discussion (Misc queries) | |||
Unicode | Excel Worksheet Functions | |||
Unicode Help | Excel Programming |