Unicode character showing in excel

  • Thread starter Thread starter chakravarthyV
  • Start date Start date
C

chakravarthyV

I have some unicode characters to be written to excel .If i tried t
write it showing as ? marks .How to write unicodes to excel.Actually
have chinese charecters which will be represented as hashcodes i
browser ,i am converting to unicodes to show in excel because exce
won't recognize hashcodes.But still i am missing somewhere.I thoug
there is problem with my conversion but i check unicodes an
corresponding character i am having ,It's fine but questions marks ar
showing.I tried like copy,paste of unicodes still same proble
exists.Please solve........
 
chakravarthyV said:
I have some unicode characters to be written to excel .If i tried to
write it showing as ? marks .How to write unicodes to excel.Actually i
have chinese charecters which will be represented as hashcodes in
browser ,i am converting to unicodes to show in excel because excel
won't recognize hashcodes.But still i am missing somewhere.I though
there is problem with my conversion but i check unicodes and
corresponding character i am having ,It's fine but questions marks are
showing.I tried like copy,paste of unicodes still same problem
exists.Please solve.........
Click to expand...

How are you converting the data? Are you using copy-and-paste to transfer
the characters? Is the worksheet formatted with a font that can display
the characters you want to see?

The key to a solution may be the creation of a User-Defined Function CharW
with the following content:

Function CharW(dec As Long) As String
CharW = ChrW(dec)
End Function

Then if you have, for example, 20049 in cell A1, you can produce the
equivalent character with the formula =CharW(A1). If you have the text
string 4E51 in cell A2, the formula becomes =CharW(Hex2Dec(A2)). If you
have HTML-style entity references, some combination of the LEFT, MID, and
RIGHT functions can be used to strip the syntactical elements from the
numeric value.
 
Back
Top