Char() for Unicode characters?

  • Thread starter Thread starter Dogmatix
  • Start date Start date
D

Dogmatix

Hi,

I'm working in Excel 2002, and I need a Function which will work lik
Char(), but will return a Unicode character for values over 256. I
appears that Char() will only work with the ordinary 8-bit ASCII set.

I have read something about a ChrW() Function which would fit the bill
but I do not appear to have this function. Can it be downloaded fro
somewhere, or can I create a Function which will work in the same way?

Any help on this would be appreciated.

Dogmati
 
I'm working in Excel 2002, and I need a Function which will work like
Char(), but will return a Unicode character for values over 256. It
appears that Char() will only work with the ordinary 8-bit ASCII set.

I have read something about a ChrW() Function which would fit the bill,
but I do not appear to have this function. Can it be downloaded from
somewhere, or can I create a Function which will work in the same way?
Click to expand...

I don't know for sure, but if you have a version of Excel that supports Unicode,
then you'd have this function already. If you have a version of Excel that
doesn't provide this function, then it's very likely you have a version of Excel
that doesn't support Unicode at all. AFAIK, if you don't have an Asian language
version of Excel, you don't have Unicode support.
 
Hi,

I'm running Excel under Windows 2000, and Unicode support is definatel
enabled (for example, I can insert Unicode characters via Insert -
Symbol, and so on.).

However, if I put, for example, =chrw(8364) or =chrw("20AC") in
cell, instead of returning the euro symbol, it says #NAME?.

I have installed the Analysis Toolpak, but the function just isn'
there. Is it perhaps hidden in an other add-in package?

Dogmati
 
AFAIK, if you don't have an Asian language
version of Excel, you don't have Unicode support.
Click to expand...

I'd say "You don't have full unicode support", since unicode characters can
still be pasted into the worksheet.
 
Dog

ChrW is a VBA function.

Sub findit()
Dim MyChar
MyChar = ChrW(288) ' Returns G.
MsgBox MyChar
End Sub

Gord Dibben Excel MVP
 
Back
Top