Char() for Unicode characters?

[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

 

[Harlan Grove]

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?

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.

 

[Dogmatix]

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

 

[Jonathan Rynd]

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

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

 

[Gord Dibben]

Dog

ChrW is a VBA function.

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

Gord Dibben Excel MVP