Generating Unicode characters in a cell using formulas

  • Thread starter Thread starter Geoff
  • Start date Start date
G

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" 一.
 
Back
Top