Unicode, Working with in Excel

Unicode Table Generated through 8360, The Euro is € (€)
See http://groups.google.com/groups?threadm=%23PU%23mfMMEHA.2584@TK2MSFTNGP12.phx.gbl

Return to Symbols for HTML and Excel use -- http://www.mvps.org/dmcritchie/rexx/htm/symbols.htm

Excel coding, Although there is no CharW Worksheet Function, a UDF can be created and can be used on the worksheet much like usage in HTML.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
 ' ⊕ ⊕ -- Circled Plus,  not avail on my US Excel 2000, Windows 2000  your use may vary 
 ' ⊕ ⊕    ⊕  only in HTML...
   [a1] = ChrW(8853)              
   [b1] = ChrW(Val("&H2295"))
   [c1] = ChrW(CDbl("&H2295"))
   [d1] = "=pesonal.xls!CharW(8853)"
 
 ' ♫ -- Beamed Eighth Notes, Is available on my system  
 ' ♫ (no Escape character) ♫   Ok in Excel and HTML
   [a2] = ChrW(9835)           
   [b2] = ChrW(Val("&H266B"))
   [c2] = ChrW(CDbl("&H266B"))
   [d2] = "=pesonal.xls!CharW(9835)"
End Sub

Option Explicit
Function CharW(dec As Long) As String
  CharW = ChrW(dec)  'D.McRitchie, 2004-05-12 public.excel
End Function

Function CodeW(str As String) As Long
  CodeW = AscW(str)  'D.McRitchie, 2004-05-12 public.excel
End Function

Function Unicode(str As String) As String
   'shows a hex value  as in   U+20AC  'D.McRitchie, 2005-09-14
   Unicode = "U+" & Right("0000" & Hex(AscW(str)), 4)
End Function

Function HexOf(dec As Long) As String
   HexOf = Hex(dec)   'D.McRitchie, 2005-09-16
End Function

Function hex2text(str As String) As String
  Dim i As Long 'D.McRitchie, 2005-09-16
  For i = 1 To Len(str) Step 2
     hex2text = hex2text & Chr(val("&H" & Mid(str, i, 2)))
  Next i
End Function

Function text2hex(str As String) As String
  Dim i As Long  'D.McRitchie, 2005-09-16
  For i = 1 To Len(str)
     text2hex = text2hex & Hex(Asc(Mid(str, i, 2)))
  Next i
End Function

key red:  Windows characters 130-159 (x'80'-x'8F') are considered invalid by W3C standards, though widely recognized and in use from the 1980's and now registered as the windows-1252 code page (Win-Latin1) at IANA [ref ref.] and are described in The ISO 8859 Alphabet Soup document.

Characters (unicode) -- Fonts, characters & the keyboard
http://www.linguistics.ucsb.edu/faculty/cumming/WordForLinguists/Fonts.htm

Microsoft Office Assistance:  Taking Advantage of Unicode Support in Office 2000
http://office.microsoft.com/en-us/assistance/HA011382921033.aspx see subtopic "Printing and displaying Unicode text"

  http://evolt.org/article/ala/17/21234/

  HTML Character Entity References Defined in HTML 4.0 - HTML Code Tutorial
  http://www.htmlcodetutorial.com/characterentities_famsupp_69.html

  Character Names Index, Unicode, Inc.
  Code Charts (PDF Version), Unicode, Inc.

  Character Sets: Code Tables, Library of Congress

The rendition of 00 through 256 is dependent on your Font Codepage.
Also see Symbols Page at http://www.mvps.org/dmcritchie/rexx/htm/symbols.htm