Symbols for HTML and Excel use

Location: http://www.mvps.org/dmcritchie/rexx/htm/symbols.htm      

 π Day   A sequential time will occur during Pi Day on 3/14/15 at 9:26:53 (3.141592653) following the sequence of pi.
Trenton Computer Festival planned to celebrate Pi Day but had to be changed to 3/21/2014 instead [TCF home page] [Count down timer][The Joy of Pi]
 
Font Tables as Rendered by your browser (fonts.htm -- CODE, Hex, CHAR, bold, symbol,  webdings, wingdings, wingdings 2, wingdings 3).  With Firefox 3, am no longer able to render Microsoft fonts in Firefox.  Also see the table on the Font Tables page for replacement tokens for the supressed characters 128-143 (x'80' - x'8F'), quick reference Pi π
Complete Guide to Pre-Installed Fonts in Linux, Mac, and Windows | A Padded Cell, by Megan McDermott, 10 November 2007
SYMBOLS for HTML and Excel use (this page, suggest linking in Firefox with a Keyword shortcut of "symbols:")
HTML Entity Names:  ★ HTML Named Special Symbols (• •, – –, © ©, &reg, ®, etc in nice layout), s/b available on all browsers;    (Reference, just names w/o glyphs: Character entity references in HTML 4.0nsHTMLEntityList.h - DXR).  Entity list is important specific entities are required of all browsers, so the characters themselves must exist dependent on HTML version.
Shapecatcher: Draw the Unicode character you want!, (Find what you are looking for) Currently, there are 11817 unicode character glyphs in the database. Japanese, Korean and Chinese characters are currently not supported. [noted: 2013-02-01]
Search form - Searching for Unicode characters by name,    ☆ Unicode Character Search (better for more hits like as part of a word),
Some interesting searches (using 1st link, you can paste a unicode character [ ☆ ] into either search):  black (“filled”, 291),  white (“outline”, 252),  box (157),  car (8),  circle (156),  diamond (41),  key (14),  open (117) / closed (41),  over (99) / under (18),  sign (3003) [3833 using second link],  space (22),  square (340),  sun (17) / moon (23),  symbol (1195),  tele* (85):  phone (12/22),  telephone (12),  telescope (1),  television (1), 
Unicode: Keyboard Symbols ⌘ ⏎ ↹ ⇄ ❖ ⌫ ⌦ ⌥ (opt), ✲ (control), ⎈, ◆, ◇, ✦, ✧, ⇧, ⏎ (Return), ▤ (menu ▤), ⇄, ⌧, ✉, ⟳, 🔎, not on your keyboard π
sample of SKIER (U+26F7) Unicode Character 'SKIER' (⛷) I find it hard to believe that the action figure skier is replaced in most browsers and now has essentially the same unicode character as 🎿 (🎿 SKI AND SKI BOOT).  New action figures were added for rowing, surfing, bicyling, mountain biking, etc and the skier figure was dropped.  Check out how your browser supports, modifies, or doesn't support a character in your fonts and fontsizes:  [π ⌘ ★ ⛷ ❖ 📅 📋 📺] (8 characters)
Browser Test Page for Unicode Character 'SKIER' (U+26F7)
Local Font List
Unicode Character 'SKIER' (U+26F7)
SKIER (U+26F7) Font Support
Unicode Wikipedia entry
Unicode-Kategorie Symbol, Other (descriptive names are in English; if you don't see the symbol in your browser most other people won't either), Unicode database
Unicode -- Geometric Shapes - Test for Unicode support in Web browsers.  Unicode.org pages:  Geometric Shapes [c],  Miscellaneous Symbols [c],  Miscellaneous Symbols and Arrows [c],  ☺ 😀 Emoticon:ListEmoji VersionsUTR #51
Unicode (new page), and Unicode through 16000 as a zipfile.  See newsgroup thread
Unicode 4.0 / ISO 10646 Plane 0, This page contains a table of the Unicode Base Multilingual Plane (BMP, Plane 0), characters U+0020 through U+2B0D, U+3040-312F, U+31A0-31FF, and U+FFF9-FFFF, encoded in Unicode Transformation Format 8 (UTF-8), except for Control and Formatting characters, which are printed as spaces. All of CJK except Hiragana, Katakana, and Bopomofu are also omitted, since including all the Han characters crashes every browser the author tried.  (as represented in your browser, of course)
Unicode 6.2 names list, semi-automatically derived from UnicodeData.txt and a set of manually created annotations using a script to select or suppress information from the data file. (Text only, no glyphs)
Unicode Escaping Tools - Online Toolz, Generates Unicode entities from a given unicode text
ASCII Codes (ASCII Symbol Names, Hex 00-7F, Octal 0-177, Decimal values 0-127)
Wingdings character set and equivalent Unicode characters, Alan Wood also has an index Unicode and multilingual support in HTML, fonts, Web browsers and other applications, and pages for Dingbats U+2700 – U+27BF (9984–10175), and Miscellaneous Symbols U+2600 – U+26FF (9728–9983)

Excel characters as seen in the US (windows-1252) (symbols_excel.htm)
HTML 4.0 Entities, The higher part of ISO-8859-1 (codes from 160-255) can all be used using character entity names. 

Character Set (names)
http://a4esl.org/c/charset.html,   Official character encoding ("charset") names, in alphabetic order,   Character Set Recognition,   Encoding.WindowsCodePage Property (System.Text)

References on this page:
Escapes (entities), tokens (symbols.htm#escapes)
Checkmarks, Tickmarks (symbols.htm#ticks)
Symbols coded as &#___; in HTML (symbols.htm#htmlsym)
Keying Characters into MS Excel (symbols.htm#msExcel) use of CharMap
Symbols in Table by their SGML entity names (#entity)
EBCDIC (#EBCDIC)
Comments and Related Information (#related)

[top]
Escapes (entities), tokens (#escapes)
Avoid 128-159
NameDescription     tokenExcel or AutoCorrect
&ampersand&& alt+38
>greater than>> alt+62
&lt;less than<&#60; alt+60
&#92;backslash\&#92; alt+0092
&#149;Bullet &#149; &#149; alt+0149
&bull;Bullet     [&#x2022]&#x2020; alt+8226
&#9642;Black Small Square &#9642; alt+0149
&diams;Diamond ♦ (see diamond) --- ---
&loz;lozenge ◊&#x25CA; &#9674;
&middot;middle dot·&#0183; alt+0183
&Egrave; EgraveÈ&#200; alt+0200
&hellip; hellip [low horizontal ellipsis]&#133; alt+0133
&hellip; hellip [low horizontal ellipsis]&#8230; alt+8230
&ntilde;ntildeñ&#241; alt+0241
&ouml;oumlö&#246; alt+0246
&nbsp;non breaking space  &#160;alt+0160
&copy;copyright sign© &#169; alt+0169 or (c)
&reg;registered sign® &#174;alt+0174 or (r)
&#trade;trademark &#153;alt+0153 or (tm)
&#8480;service mark (&#8480) SM) &#x2120;alt+8480 or (SM)
&quot;double quote"&#34; alt+0034
&euro;Euro (€ &#x20AC;)&#8364; alt+0128 (euro)
&#162;cent¢&#0162; alt+0162
&not;Not sign¬&#0172; alt+0172
&circ;circumflex (or caret) signˆ&#0710; alt+0710
&para;paragraph (pilcrow sign)&#0182; alt+0182
&plusmn;plus-minus±&#0177; alt+0177
&pi;pi π&#x03C0;alt+0960
&#8984;place of interest / misc technical &#x2318;alt+8984
&#9401;Circled letter D &#24B9;alt+9401
&#9744;Ballot Box&#x2610; &#x2610;
&#9745;Ballot Box with Check&#9745; &#x2611;
&#9746;Ballot Box with X&#9746; &#x2612;
&#9747;Saltire&#x2613; &#9747;
&#10003;Checkmark&#x2713; &#10003;
&#10004;Heavy Checkmark&#x2714; &#10004;
&#10005;Multiplication X&#x2715; &#10005;
&#10006;Heavy Multiplication X&#x2716; &#10006;
&#10007;Ballot X&#x2717; &#10007;
&#10008;Heavy Ballot X&#x2718; &#10008;
Symbols used on keyboards and Browser Documentation
&#x21BB;CLOCKWISE OPEN CIRCLE ARROW () &#x21BB;alt+8635
&#x21C4;RIGHT ARROW OVER LEFT ARROW (used as TAB on PC) &#x21C4;alt+8644
&#x2261;IDENTICAL TO (used as Menu, or in Dolphin for Control Panel &#x2261;alt+8801
&#x2326;Erase to the Right &#x2326;alt+8998
&#x2327;X IN A RECTANGLE BOX &#x2327;alt+8999
&#x232B;Erase to the Left &#x232B;alt+9003
&#x2396;DECIMAL SEPARATOR KEY SYMBOL &#x2396;alt+9110
&#x23CE;RETURN SYMBOL &#x23CE;alt+9166
&#x241B;Symbol for Escape &#x241B;alt+9243
&#x2672;UNIVERSAL RECYCLING SYMBOL &#x2672;alt+9842
&#x2732;OPEN CENTRE ASTERISK &#x2732;alt+10034
&#x2750;Upper right-shadowed white square &#x2750;alt+10064
&#x2756;BLACK DIAMOND MINUS WHITE X (WinKey) &#x2756;alt+10070
&#x2AF6;Triple Colon Operator (used as a Menu) &#x2AF6;alt+10998
&#x1D11A;Musical symbol five-line staff: 𝄚&#x1D11A;alt+119066
&#x1D364;Counting rod unit digit five: 𝍤&#x1D364;alt+119652
&#x1F4CB;Clipboard 📋&#x1F4CB;alt+128203
Symbols below are not available throughout IE, Firefox, Opera
(Star)Star in wingdinguse &#9733; alt+0171 (wingdings)
(Star)Star in wingding&#182; alt+0182 (wingdings)
&shy;soft hyphen [CSS]­&#0173; alt+0173
 REFERENCE MARK (Punctuation) &#x203B;alt+8251
 DOTTED CROSS (Punctuation) &#x205C;alt+8284
 Tricolon (Punctuation) &#x205D;alt+8285
 CIRCLED MINUS &#x2296;alt+8854
 CIRCLED TIMES &#x2297;alt+8855
 CIRCLED DIVISION SLASH &#x2298;alt+8856
 CIRCLED ASTERISK OPERATOR &#x229B;alt+8859
 CIRCLED EQUALS &#x229C;alt+8860
 CIRCLED DASH &#x229D;alt+8861
 Star Operator &#x22C6;alt+8902
&vellip;Vertical ellipsis &#x22EE;alt+8942
&#x25A4;SQUARE WITH HORIZONTAL FILL (used as menu)&#x25A4;alt+9636
&#x25B2;BLACK UP-POINTING TRIANGLE&#x25B2;alt+9650
&#x26F7;Skier (or boot and skis)&#x26F7;alt+9975
 BLACK RIGHT-POINTING TRIANGLE&#x25B6;alt+9654
 BLACK RIGHT-POINTING POINTER&#x25BA;alt+9658
&#x25BC;BLACK DOWN-POINTING POINTER&#x25BC; alt+9660
 BLACK LEFT-POINTING TRIANGLE&#x25C0; alt+9664
 BLACK LEFT-POINTING POINTER&#x25C4; alt+9668
 WHITE SQUARE CONTAINING SMALL BLACK SQUARE&#x25A3; alt+9603
 WHITE DIAMOND CONTAINING BLACK SMALL DIAMOND&#x25C8; alt+9672
 FISHEYE (Japanese Bullet)&#x25C9; alt+9673
 BULLSEYE&#x25CE; alt+9678
 BLACK CIRCLE&#x25CF; alt+9679
 Black Sun with Rays &#x2600;alt+9728
 Cloud = cloudy weather &#x2601;alt+9729
 Umbrella = rainy weather &#x2602;alt+9730
 Sun &#x2609;alt+9737
 Umbrella with rain drops &#x2614;alt+9748
 White Sun with rays &#x263C;alt+9788
 STAR OPERATOR &#x22C6;alt+8902
&starf;Black Star&#x2605; alt+9733
&star;White Star&#x2606; alt+9734
 OPEN CENTER BLACK STAR &#x272B;alt+10027
 BLACK CENTER WHITE STAR &#x272C;alt+10028
 OUTLINED BLACK STAR &#x272D;alt+10029
 OUTLINED BLACK STAR &#x272E;alt+10030
 HEAVY OUTLINED BLACK STAR &#x272F;alt+10031
 OUTLINED WHITE STAR &#x2730;alt+10032
 EIGHT SPOKED ASTERISK &#x2733;alt+10035
 EIGHT POINTED BLACK STAR &#x2734;alt+10036
 Position indicator, register mark, target &#x2616; alt+8982
 APL FUNCTIONAL SYMBOL CIRCLE JOT &#x233E;alt+9022
 APL FUNCTIONAL SYMBOL CIRCLE STAR &#x235F;alt+10687
 Circled bullet ⦿&#x29BF;alt+10687
 N-ARY CIRCLED DOT OPERATOR &#x2A00;alt+10752
 N-ARY CIRCLED PLUS OPERATOR &#x2A01;alt+10753
 N-ARY CIRCLED TIMES OPERATOR &#x2A02;alt+10754
 CIRCLED DIVISION SIGN &#x2A38;alt+10808
 Triple colon operator &#x2AF6;alt+10998
 CALENDAR (on Android appears to have been added as color icon by "Office Suite 8 + PDF Converter" App) 📅&#x1F4C5;alt+128197
 TELEVISION 📺&#x1F4FA;alt+128250
                Searching in Unicode character names (in hex)Decimal to Hexadecimal ConverterHexadecimal to Decimal Converter
HTML escape sequences (with names) are case sensitive.  Hex notation is not case sensitive.
Tokens can be in decimal &#8364; or in hex &#x20ac (not case sensitive).
★☆ ✫ ✬ ✭ ✯★☆ ✫ ✬ ✭ ✯To see the STARS shine in full glory, you will probably have to
use a font-size of 200% such as to see the Outlined Black Star.
"Special" Windows characters [130-159] and their ISO 10646 equivalents
HTML White space characters, line breaks, soft hyphens.
Miscellaneous Symbols - The Unicode Standard 6.0 2600-26FF unicode.org
Unicode Character Set, dansort.com, characters U+0000 – U+FFFF) of the Unicode character set. Enter the character code that you would like to view (either hexadecimal or decimal) and select the appropriate button. 
  Interactive, easiest to work with tables:  2600-26FF Miscellaneous Symbols,  2700-27BF Dingbats
Miscellaneous Symbols Range: 2600–26FF unicode symbols [PDF] (standard 3.2)
Microsoft - Latin 1- Punctuation Design Standards, design of typography
Character entity references in HTML 4 (www.w3.org)
HTML 4.0 Entities for Symbols and Greek Letters

HTML
name
Description MS illegal
(128-159)
Unicode Unicode (U+)
(hexidecimal)
 &euro; Euro Symbol €  &#128; &#8364;  &#x20AC;
 &hellip; ellipsis (horiz.) …  &#133 &#8230;  &#x2026;
 &dagger; dagger †  &#134; &#8364;  &#x2020;
 &Dagger; double dagger ‡  &#135; &#8364;  &#x2021;
 &rsquo; apostrophe ’  &#146; &#8217;  &#x2019;
 &ldquo; open double quote “  &#147; &#8220;  &#x201C;
 &rdquo; close double quote ”  &#148; &#8221;  &#x201D;
 &lsquo; open single quote ‘  &#145; &#8216;  &#x2018;
 &rsquo; close single quote ’  &#146; &#8217;  &#x2019;
 &bull; bullet •  &#149; &#8226;  &#x2022;
 &mdash; em-dash —  &#151; &#8212;  &#x2014;
 &ndash; en-dash –  &#150; &#8211;  &#x2013;
 &tilde; tilde ˜  &#152; &#732;  &#x02DC;
 &#8480; Service Mark ℠ ℠   &#8480; &#x2120;
 &trade; Trademark (tm)  ™  &#153; &#8482;  &#x2122;
 &cent; Cent Sign ¢ &#162;  &#162; 
 &pound; Pound Sterling                £  &#163; &#163; 
 &curren; Currency Sign                ¤  &#164; &#164; 
 &yen; Yen Symbol                      ¥  &#165; &#65509; &#xFFE5;
 &copy; Copyright  (c)            ©  &#169; &#169; 
 &not; not sign  ¬  &#172; &#172; 
 &reg; Registered (r)  ®  &#174; &#174; 
 &macr; macron (spacing overline) ¯  &#175; &#175; 
 &deg; Degree          °  &#176; &#176; 
 &plusmn; Plus/Minus          ±  &#177; &#177; 
 &para; Pilcrow ¶ &#182;  &#182; 
HTML Entities and Codings The Trouble With EM ’n EN (and Other Shady Characters): A List Apart
Wikipedia: Punctuation, Currency sign

 

CharacterNamed entityTokenDescription
Arrows
&larr;&#8592; leftward arrow, U2190 ISOnum
&uarr;&#8593; upward arrow, U2191 ISOnum
&rarr;&#8594; rightward arrow, U2192 ISOnum
&darr;&#8595; downward arrow, U2193 ISOnum
&harr;&#8596; left right arrow, U2194 ISOamsa
&crarr;&#8629; downward arrow with corner leftward, =carriage return, U21B5 NEW
&lArr;&#8656; leftward double arrow, U21D0 ISOtech
&uArr;&#8657; upward double arrow, U21D1 ISOamsa
&rArr;&#8658; rightward double arrow, U21D2 ISOtech
&dArr;&#8659; downward double arrow, U21D3 ISOamsa
&hArr;&#8660; left right double arrow, U21D4 ISOamsa
xxxx&#10232;  
xxxx&#10233;  
Portion of Table from MSDN ▶ MSDN Library ▶ Web Development ▶ HTML and CSS ▶ HTML and DHTML Reference ▶ Additional Named Entities for HTML

 

Checkmarks, Tickmarks (#ticks)
Table can no longer be rendered in Firefox 3 and up
due to webdings and wingdings.

Internet Explorer 8 will render 11 of 13
Safari render 4 of 13 Font
 Symbol   bold   CHAR   CODE   Hex   token   Excel 
"Monotype Sorts" 3 3 351 0x33 &#33;   alt+0033 
"Monotype Sorts"  4 4 452 0x34&#34; alt+0034
"Webdings"a a a97 0x61&#61; alt+0061
"Wingdings"û û û251 0xFB &#FB;   alt+00FB 
"Wingdings"ü ü ü252 0xFC &#FC;   alt+00FC 
"Wingdings"ý ý ý253 0xFD &#FD;   alt+00FD 
"Wingdings"þ þ þ254 0xFE &#FE;   alt+00FE 
"Wingdings 2" O O O80 0x49&#49; alt+0049
"Wingdings 2" P P P81 0x50&#50; alt+0050
"Wingdings 2" Q Q Q82 0x51&#51; alt+0051
"Wingdings 2" R R R83 0x52&#52; alt+0052
"Wingdings 2" S S S83 0x53 &#53;   alt+0053 
"Wingdings 2" T T T84 0x54 &#54;   alt+0054 
See (#ticks) on Excel Event Macros page for some coding.
To create a tickmark symbol in Excel, Change the font to "Wingdings 2" and type in a Capital "P"; If you don't know the character to use, you can find it in the Character Map.  Unlike MS Word you must change the font, simply pasting from the CharMap is not sufficient.
The use of &quot; was accidentally dropped from the HTML 3.2 standard but is probably universally accepted -- use &#34; to conform to standard.  Should no longer affect anyone as HTML 3.2 is now rather old.

Front Page 98 incorrectly inserts &trade; into HTML that does not work with Netscape. [ref]

Front Page uses Ctrl+Shift+Space to generate a non-breaking space character (&nbsp;), which is much easier than Alt+0160 on a laptop but does not work in Excel.

A service mark (SM) can be generated in HTML with <small><sup>SM</sup></small> and a trademark (TM)) can be generated in HTML with <small><sup>(TM)</sup></small> if there is the possibility of incompatibility of character sets.  misspelling: trade mark

Articles of interest: On the use of some MS Windows characters in HTML concerning the MS Windows character set additions (chars 128-159) to ISO 8859-1, when seen by non-Windows users (particularly Unix), and ISO Latin 1 (ISO 8859-1) and ISO Latin 1.

"Special" Windows characters [130-159] and their ISO 10646 equivalents. 
Standard refrain for HTML usage is to refrain from using "Special" Windows characters in HTML.

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.

ASCII - ISO 8859-1 Table with HTML Entity Names, The following table lists all known HTML entity names along with their ASCII / ISO 8859-1 (Latin-1) character names and codes, if any. Most of these HTML entity names are those of the ISO 8879 entity sets. Note that the first 128 character codes of any of the ISO 8859 character sets is always identical to the ASCII character set.

Character Encoding in browser test page: http://en.wikipedia.org/wiki/Polytonic_Greek
Firefox:  View, Character Encoding,
  Western (ISO 8859-1) is what I see in Safe Mode -- I am in US (Windows 2000).
&nbap; Unicode (UTF-8) is what I was using when I looked on 2007-03-22.
IE6:  View, Encoding, Western European (ISO)

Possible Background Colors.  This page is using FFFEF4.    [fffef4]

Symbols coded as &#___; in HTML   (#htmlsym)

The values probably vary depending on the translation table used. 
An Excel version of this table can be found at Excel characters as seen in the US (windows-1252)
 
FONT Table  showing the fonts: Arial, Symbols, Webdings, Wingdings, Wingdings 2, Wingdings 3.

  _ 0 _ 1 _ 2 _ 3 _ 4 _ 5 _ 6 _ 7 _ 8 _ 9 _ A _ B _ C _ D _ E _ F
2 _ 32
33
!
34
"
35
#
36
$
37
%
38
&
39
'
40
(
41
)
42
*
43
+
44
,
45
-
46
.
47
/
3 _ 48
0
49
1
50
2
51
3
52
4
53
5
54
6
55
7
56
8
57
9
58
:
59
;
60
<
61
=
62
>
63
?
4 _ 64
@
65
A
66
B
67
C
68
D
69
E
70
F
71
G
72
H
73
I
74
J
75
K
76
L
77
M
78
N
79
O
5 _ 80
P
81
Q
82
R
83
S
84
T
85
U
86
V
87
W
88
X
89
Y
90
Z
91
[
92
\
93
]
94
^
95
_
6 _ 96
`
97
a
98
b
99
c
100
d
101
e
102
f
103
g
104
h
105
i
106
j
107
k
108
l
109
m
110
n
111
o
7 _ 112
p
113
q
114
r
115
s
116
t
117
u
118
v
119
w
120
x
121
y
122
z
123
{
124
|
125
}
126
~
127

8 _ 128
129

130
131
ƒ
132
133
134
135
136
ˆ
137
138
Š
139
140
Œ
141

142
Ž
143

9 _ 144

145
146
147
148
149
150
151
152
˜
153
154
š
155
156
œ
157

158
ž
159
Ÿ
A _ 160
 
161
¡
162
¢
163
£
164
¤
165
¥
166
¦
167
§
168
¨
169
©
170
ª
171
«
172
¬
173
­
174
®
175
¯
B _ 176
°
177
±
178
²
179
³
180
´
181
µ
182
183
·
184
¸
185
¹
186
º
187
»
188
¼
189
½
190
¾
191
¿
C _ 192
À
193
Á
194
Â
195
Ã
196
Ä
197
Å
198
Æ
199
Ç
200
È
201
É
202
Ê
203
Ë
204
Ì
205
Í
206
Î
207
Ï
D _ 208
Ð
209
Ñ
210
Ò
211
Ó
212
Ô
213
Õ
214
Ö
215
×
216
Ø
217
Ù
218
Ú
219
Û
220
Ü
221
Ý
222
Þ
223
ß
E _ 224
à
225
á
226
â
227
ã
228
ä
229
å
230
æ
231
ç
232
è
233
é
234
ê
235
ë
236
ì
237
í
238
î
239
ï
F _ 240
ð
241
ñ
242
ò
243
ó
244
ô
245
õ
246
ö
247
÷
248
ø
249
ù
250
ú
251
û
252
ü
253
ý
254
þ
255
ÿ
  _ 0 _ 1 _ 2 _ 3 _ 4 _ 5 _ 6 _ 7 _ 8 _ 9 _ A _ B _ C _ D _ E _ F

ASCII Charts, Chart 1 (codes 0–127), Chart 2 (codes 128-255)
Unicode (new page), and Unicode through 16000 as a zipfile.  See newsgroup thread
ASCII Codes (ASCII Symbol Names, Hex, Octal, Decimal values)

     Character Map  (START, Programs, Accessories) (#charmap)
    can be added to your Excel Toolbar or Toolbar menu

The Euro represented by 0128 is a Microsoft convention, but if it is is selected and copied with the COPY button, it will be available in paste.  Also note the number will be shown in the lower right corner and can be keyed in as follows:
      Alt+0128 on the numeric keypad (Num Lock on). 
      On a laptop use  Fn+Alt+0128 on numeric keypad with NumLock off. 
You will see this form with subset: Windows Characters; otherwise, you will see hexidecimal characters.  See code for Character Map below.

Use 4 digits with ALT key, refer to MS-DOS Codepage 437 (US) or 850 (Multilingual Latin 1) to see how Alt+0176 is same as Alt+248 (both of these old codepages have the box characters).  A more modern code page is Windows Code Page 1252.


Excel:  superscript, subscript, and strikeout are available by selecting character(s) on formula bar then using Format, Cells, (font tab), choice of font attributes can also include colors.

Mathematical symbols in HTML see Related at bottom.

Keying Characters into MS Excel   (#msexcel)

Referring to the above table (characters displayed depend on the translation table used)

To type the paragraph symbol (¶), use ALT+0182, the number must be from the numeric keypad

For Excel to use a different font you must use the font drop down box.  In word if you copy a character you copy both the character and the font.

In a macro Ö [umlaut O] :
   ActiveCell.Value = Chr(214)

on a Worksheet:
  =CHAR(214)

Copy and Paste:
You will have to change the font
if it has a different codepage.
Excel does not give you control over font codepages.

Autocorrect: (tools menu)
 i.e.   (c) changes to ©,  (r) to ®,  and (tm) to ™
Use Ctrl+z (undo) to undo unwanted changes

      by typing (only works on numeric keypad):
  NumLock Alt+0214     (in Europe use RtAlt)

On American keyboards there is no distinction between LtAlt or RtAlt.
NumLock is not needed on the macro sheet on my XL95.

Character Map: [Start],Program,accessories
Find symbols, paste from here or find the keystroke code in the lower right corner, comprised of Alt and 4-digit ASCII number code.  Subset is as close to the font codepage as you will see in Excel.  If you see Unicode by the code then you have been supplied the hexidecimal code. 

To find the ASCII code of a single pasted character use CODE(char):
    =CODE("A")     yields 65 for "A",   Alt+0065 is "A"
    =CHAR(65)       yields "A" for code 65

Here is a CharMap button (16x16 pixels) you can install in
a menu or on a toolbar in conjunction with the following macro.

Sub showCharMap()
 Dim vCharMap as String 
 'vCharMap = Shell("C:\Windows\CharMap.exe", 1)
 'vCharMap = Shell("C:\winnt\system32\CharMap.exe", 1)
 vCharMap = Shell("C:\winnt\SysWOW64\CharMap.exe", 1)
End Sub
Chip Pearson has a Symbolizer Addin to access 200 symbols.  (I'd stick with CharMap myself)
 
If you are using Excel 2002 you can use   Insert, Symbol.
 
MS Word has a more direct route to the CharMap using Insert, Symbol.

The Euro currency symbol - euro FAQ on the MS KB.  takes on greater importance as the euro is now in use.  How to obtain fonts and how to key in.  The symbol appears as a large C with two cross bars €, if you see it here properly you have been updated.  WinNT 4.0 SP4 updated my system.  On US keyboards (FAQ footnote) use the numeric keypad Alt+0128 (with or w/o num lock). 

Concerning that the Euro symbol does not appear in the Latin-1 char map with Arial, for instance.  I expect that the WWW3 folks have not approved anything for the reserved Chars 128-159, which correspond with reserved Chars 0-31 (that's 00-1F, and 80-9F)
    START --> Accessories --> Char Map
It is found in the Windows character set six characters after lowercase z.

More Euro information:
http://www.microsoft.com/OpenType/faq/faq12.htm
http://www.microsoft.com/typography/fontpack/default.htm
http://www.microsoft.com/windows/euro.asp
http://www.microsoft.com/typography/news/whatsnew.htm
http://europa.eu.int/euro/html/home5.html?lang=5 The European Commission's Web site on the euro
http://europa.eu.int/euro/html/calendrier5.html?lang=5 -- Euro Timetable, coins & currency Jan 1, 2002.

And if you have updated your Excel look in HELP
F1 (Help) --> answer wizard --> Euro --> Entering, displaying, and printing the euro sign

72° 14' 32" -- Displaying Latitude & Longitude, code as time by dividing degrees by 24 to appear as hours, and format the cell as [h]° mm' ss\"  under Format|Custom where the degree symbol is typed ALT+0176 on the numeric keypad.  Nautical Waypoints, example file, "great circle & rhumb line" by Vedran Cetkovic For formatting a temperature: #"°F"

This HTML page will Convert Latitude / Longitude in Degrees/Minutes/Seconds to/from Decimal (FCC) USA, HTML utility permits the user to convert latitude and longitude between decimal degrees and degrees, minutes, and seconds.  For convenience, a link is included to the National Geodetic Survey's NADCON

Note:  0176 is the degree symbol, 0186 looks similar is actually a superscript zero and is a little larger. 

Additional examples of the above decimal conversions can be found on my formula page.

If you need to sort a column of alphabetic characters and numbers in an EBCDIC simulation in Excel see sorting for an abbreviated solution that sorts letters and numbers and equal(=) and minus(-).

Excel has it's own collating sequence for sorting.  Numbers are sorted before text, text is sorted in the following order (upper and lowercase sort equal).  The following table shows the Excel collating sequence for text cells char(32) to Char(127).

39
'
45
-
32
 
33
!
34
"
35
#
36
$
37
%
38
&
40
(
41
)
42
*
44
,
46
.
47
/
58
:
59
;
63
?
64
@
91
[
92
\
93
]
94
^
95
_
43
+
60
<
61
=
62
>
48
0
49
1
50
2
51
3
52
4
53
5
54
6
55
7
56
8
57
9
65
A
66
B
67
C
68
D
69
E
70
F
71
G
72
H
73
I
74
J
75
K
76
L
77
M
78
N
79
O
80
P
81
Q
82
R
83
S
84
T
85
U
86
V
87
W
88
X
89
Y
90
Z

Related Excel Newsgroup articles:  inputting symbols (this article not found 2000-05-29).

See My Excel Pages if you would like to see more of what I have written about MS Excel.

Symbols in Table by their SGML entity names (#entity)

The following are not HTML names, but may help you correctly identify the characters. This table was obtained from Hypertext Markup Language - 2.0 - HTML Public Text

ISO Latin 1 Character Entity Set

The following public text lists each of the characters specified in the Added Latin 1 entity set, along with its name, syntax for use, and description.  This list is derived from ISO Standard 8879:1986//ENTITIES Added Latin 1//EN.  HTML includes the entire entity set. Another version of this listing based on ISO-8859-1 can be found at http://www.w3.org/MarkUp/html-spec/html-spec_13.html

The WWW3 folks have not approved anything for the reserved Chars 128-159, which correspond with reserved Chars 0-31, so you may not find Microsoft unauthorized extensions on WWW3.  So here is a link to a table for The ANSI Character Set [http://www.fingertipsoft.com/3dkbd/ansitable.html] as used on a Windows PC.  (will only view properly with a Windows PC character set and code tables in your browser.)

<!-- (C) International Organization for Standardization 1986
     Permission to copy in any form is granted for use with
     conforming SGML systems and applications as defined in
     ISO 8879, provided this notice is included in all copies.
-->
<!-- Character entity set. Typical invocation:
     <!ENTITY % ISOlat1 PUBLIC
       "ISO 8879-1986//ENTITIES Added Latin 1//EN//HTML">
     %ISOlat1;
-->
<!--    Modified for use in HTML
$Id: ISOlat1.sgml,v 1.2 1994/11/30 23:45:12 connolly Exp $ -->
<!ENTITY AElig  CDATA "&#198;" -- capital AE diphthong (ligature) -->
<!ENTITY Aacute CDATA "&#193;" -- capital A, acute accent -->
<!ENTITY Acirc  CDATA "&#194;" -- capital A, circumflex accent -->
<!ENTITY Agrave CDATA "&#192;" -- capital A, grave accent -->
<!ENTITY Aring  CDATA "&#197;" -- capital A, ring -->
<!ENTITY Atilde CDATA "&#195;" -- capital A, tilde -->
<!ENTITY Auml   CDATA "&#196;" -- capital A, dieresis or umlaut mark -->
<!ENTITY Ccedil CDATA "&#199;" -- capital C, cedilla -->
<!ENTITY ETH    CDATA "&#208;" -- capital Eth, Icelandic -->
<!ENTITY Eacute CDATA "&#201;" -- capital E, acute accent -->
<!ENTITY Ecirc  CDATA "&#202;" -- capital E, circumflex accent -->
<!ENTITY Egrave CDATA "&#200;" -- capital E, grave accent -->
<!ENTITY Euml   CDATA "&#203;" -- capital E, dieresis or umlaut mark -->
<!ENTITY Iacute CDATA "&#205;" -- capital I, acute accent -->
<!ENTITY Icirc  CDATA "&#206;" -- capital I, circumflex accent -->
<!ENTITY Igrave CDATA "&#204;" -- capital I, grave accent -->
<!ENTITY Iuml   CDATA "&#207;" -- capital I, dieresis or umlaut mark -->
<!ENTITY Ntilde CDATA "&#209;" -- capital N, tilde -->
<!ENTITY Oacute CDATA "&#211;" -- capital O, acute accent -->
<!ENTITY Ocirc  CDATA "&#212;" -- capital O, circumflex accent -->
<!ENTITY Ograve CDATA "&#210;" -- capital O, grave accent -->
<!ENTITY Oslash CDATA "&#216;" -- capital O, slash -->
<!ENTITY Otilde CDATA "&#213;" -- capital O, tilde -->
<!ENTITY Ouml   CDATA "&#214;" -- capital O, dieresis or umlaut mark -->
<!ENTITY THORN  CDATA "&#222;" -- capital THORN, Icelandic -->
<!ENTITY Uacute CDATA "&#218;" -- capital U, acute accent -->
<!ENTITY Ucirc  CDATA "&#219;" -- capital U, circumflex accent -->
<!ENTITY Ugrave CDATA "&#217;" -- capital U, grave accent -->
<!ENTITY Uuml   CDATA "&#220;" -- capital U, dieresis or umlaut mark -->
<!ENTITY Yacute CDATA "&#221;" -- capital Y, acute accent -->
<!ENTITY aacute CDATA "&#225;" -- small a, acute accent -->
<!ENTITY acirc  CDATA "&#226;" -- small a, circumflex accent -->
<!ENTITY aelig  CDATA "&#230;" -- small ae diphthong (ligature) -->
<!ENTITY agrave CDATA "&#224;" -- small a, grave accent -->
<!ENTITY aring  CDATA "&#229;" -- small a, ring -->
<!ENTITY atilde CDATA "&#227;" -- small a, tilde -->
<!ENTITY auml   CDATA "&#228;" -- small a, dieresis or umlaut mark -->
<!ENTITY ccedil CDATA "&#231;" -- small c, cedilla -->
<!ENTITY eacute CDATA "&#233;" -- small e, acute accent -->
<!ENTITY ecirc  CDATA "&#234;" -- small e, circumflex accent -->
<!ENTITY egrave CDATA "&#232;" -- small e, grave accent -->
<!ENTITY eth    CDATA "&#240;" -- small eth, Icelandic -->
<!ENTITY euml   CDATA "&#235;" -- small e, dieresis or umlaut mark -->
<!ENTITY iacute CDATA "&#237;" -- small i, acute accent -->
<!ENTITY icirc  CDATA "&#238;" -- small i, circumflex accent -->
<!ENTITY igrave CDATA "&#236;" -- small i, grave accent -->
<!ENTITY iuml   CDATA "&#239;" -- small i, dieresis or umlaut mark -->
<!ENTITY ntilde CDATA "&#241;" -- small n, tilde -->
<!ENTITY oacute CDATA "&#243;" -- small o, acute accent -->
<!ENTITY ocirc  CDATA "&#244;" -- small o, circumflex accent -->
<!ENTITY ograve CDATA "&#242;" -- small o, grave accent -->
<!ENTITY oslash CDATA "&#248;" -- small o, slash -->
<!ENTITY otilde CDATA "&#245;" -- small o, tilde -->
<!ENTITY ouml   CDATA "&#246;" -- small o, dieresis or umlaut mark -->
<!ENTITY szlig  CDATA "&#223;" -- small sharp s, German (sz ligature) -->
<!ENTITY thorn  CDATA "&#254;" -- small thorn, Icelandic -->
<!ENTITY uacute CDATA "&#250;" -- small u, acute accent -->
<!ENTITY ucirc  CDATA "&#251;" -- small u, circumflex accent -->
<!ENTITY ugrave CDATA "&#249;" -- small u, grave accent -->
<!ENTITY uuml   CDATA "&#252;" -- small u, dieresis or umlaut mark -->
<!ENTITY yacute CDATA "&#253;" -- small y, acute accent -->
<!ENTITY yuml   CDATA "&#255;" -- small y, dieresis or umlaut mark -->

EBCDIC (#ebcdic)

The following table as extracted from a SAS Institute document -- SAS System Support for International Character Sets  http://www.sas.com/service/techsup/nls_article.html. which is used here to illustrate some of the problems in converting from ASCII to EBCDIC.

One problem with EBCDIC is that, on different code pages, the same code point might be used for different characters.

Table 1: Examples of National Character Assignments in EBCDIC:
EBCDIC      EBCDIC Character (hexadecimal code point)
Language(s)    Code Page   4A  4F  5A  5B  5F  6A  7B  7C  A1  C0  D0  E0
-------------------------------------------------------------------------
U.S. English     CP037      ¢   |   !   $   ¬   ¦   #  @   ~   {   }   \
U.K. English     CP285      $   |   !   £   ¬   ¦   #  @   ­   {   }   \
Austrian/German  CP273      Ä   !   Ü   $   ^   ö   #  §   ß   ä   ü   Ö
Danish/Norwegian CP277      #   !   ¤   Å   ^   ø   Æ  Ø   ü   æ   å   \
Finnish/Swedish  CP278      §   !   ¤   Å   ^   ö   Ä  Ö   ü   ä   å   É
French           CP297      °   !   §   $   ^   ù   £  à   ¨   é   è   ç
Italian          CP280      °   !   é   $   ^   ò   £  §   ì   à   è   ç
Spanish          CP284      [   |   ]   $   ¬   ñ   Ñ  @   ¨   {   }   \
International    CP500      [   !   ]   $   ^   ¦   #  @   ~   {   }   \
=========================================================================

The following historic EBCDIC table was based on a document presenting a history of punched cards and their punches.  You may like to take a look at Doug Jones's "Punched Card Codes" at  http://www.cs.uiowa.edu/~jones/cards/codes.html.  For ASCII and EBCDIC Control codes see http://www.macdonald.egate.net/CompSci/Pascal/hdatatypes.html#asciicontrol

Punch card codes are included but not the newer characters added to various codepages; and therefore, avoids additional problems related to codepages.  The table includes the characters used in Assembler, COBOL, FORTRAN, PL/I, and REXX as used on mainframes.

0
1
2
3
4
5
6
7
8
9
A
B
C
D
E
F
Pch
Pch
00
NUL
(1)
 
 
 
PF
HT
LC
DEL
 
 
 
 
 
 
 
 
12
9
10
 
 
 
TM
RES
NL
BS
IL
 
 
 
 
 
 
 
 
11
9
20
DS
(2)
SOS
FS
 
BYP
LF
EOB
PRE
 
 
 
 
 
 
 
 
10
9
30
 
 
 
 
PN
RS
UC
EOT
 
 
 
 
 
 
 
 
  
40
SP
(3)
 
 
 
 
 
 
 
 
 
¢
.
<
(
+
|
12
 
50
&
(4)
 
 
 
 
 
 
 
 
 
!
$
*
)
;
¬
11
 
60
-
(5)
/
 
 
 
 
 
 
 
 
 
,
%
_
>
?
10
 
70
 
 
 
 
 
 
 
 
 
 
:
#
@
'
=
"
  
80
 
a
b
c
d
e
f
g
h
i
 
 
 
 
 
 
12
10
90
 
j
k
l
m
n
o
p
q
r
 
 
 
 
 
 
11
12
A0
 
 
s
t
u
v
w
x
y
z
 
 
 
 
 
 
10
11
B0
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
  
C0
 
A
B
C
D
E
F
G
H
I
 
 
 
 
 
 
12
 
D0
 
J
K
L
M
N
O
P
Q
R
 
 
 
 
 
 
11
 
E0
 
 
S
T
U
V
W
X
Y
Z
 
 
 
 
 
 
10
 
F0
0
1
2
3
4
5
6
7
8
9
 
 
 
 
 
 
  
Pch
0
1
2
3
4
5
6
7
8
9
2-8
3-8
4-8
5-8
6-8
7-8
  

The content from the small letter "w" in the above table to the end of this page was destroyed on or before Sep 9, 2006 by a bad Firefox extension (Web Developer in Firefox 2.0, which has been fixed) and the remainder of this page had to be restored Feb 21, 2007 from an archived copy taken in Jan 2006, so some links at the end have almost certainly been lost.

Warning the punches marked along the right and bottom are over simplified and ONLY apply to cells which are showing a value.  There are MANY exceptions including the following which appear in the chart.  THIS AREA NEEDS A LOT MORE WORK.  ALSO translations to or from ASCII are not consistent or reversible.  Translations depend on your systems.

(1) NUL12-0-1-8-9
(2) DS 11-0-1-8-9
(3) SP blank (space), no punches
(4) &12
(5) - 11

Related Materials


Other Comments

This page was created sometime before May 30, 1997. 

Please send your comments concerning my pages or materials to:  David using send email comments

Disclaimer and site usage:  Material at The REXX Macros Toolbox is available without warranty of any kind.  Redistribution of source, coding and documentation other than from this site is prohibited.

Copyright © 1995 - 2007, F. David McRitchie, All Rights Reserved