Generating Unicode characters in a cell using formulas

[Geoff]

With older multibyte Chinese code sets like Big5, I could
create a large list or table of Chinese characherts by
generating their two components with a formula like

=CHAR(HEX2DEC(LEFT(A5,2)))&CHAR(HEX2DEC(RIGHT(A5,2)))

were the hex code for the character (eg. A440) was in tyhe
target cell A5.

With Unicode, all I get are the two individual characters
that (in Big5 anyway) made up the multi-byte code for a
character.

BTW: In the case above, Big5 A440 is Unicode U+4e00, the
character for "one" 一.

 

[David McRitchie]

Hi Geoff,
You will have to create a User Defined Function for use on your worksheet

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

To install see
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Unicode, Working with in Excel
http://www.mvps.org/dmcritchie/rexx/htm/unicode.htm
a larger table is also available, or generate you own