Appendix A: ASCII Character Codes

This appendix is a listing of the 255 ASCII (American Standard Code for Information Interchange) character codes that Excel uses. They work in conjunction with the functions Asc and Chr . Asc will give the ASCII number of a character, and Chr will give the character based on an ASCII number.

All these characters can be used to produce text strings by using the Chr function (see Chapter 5). Here is an example that will produce the string ‚“ABC ‚½:

 MsgBox Chr(65) & Chr(66) & Chr(67) 

You can also insert carriage return and line feed characters to make your text wrap at the correct point.

In the table, the _ symbol indicates that there is not a displayable character.

ASCII Code	Character
1	_
2	_
3	_
4	_
5	_
6	_
7	_
8	_
9	Tab
10	Line feed
11	Home
12	Form feed
13	Carriage return
14	_
15	_
16	_
17	_
18	_
19	_
20	_
21	_
22	_
23	_
24	_
25	_
26	_
27	_
28	_
29	_
30	_
31	_
32	Space
33	!
34	"
35	#
36	$
37	%
38	&
39	'
40	(
41	)
42	*
43	+
44	,
45	-
46	.
47	/
48
49	1
50	2
51	3
52	4
53	5
54	6
55	7
56	8
57	9
58	:
59	;
60	<
61	=
62	>
63	?
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
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	_
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
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	_
128	‚¾
129	_
130	‚
131
132	‚¾
133	...
134	‚
135	‚
136	‹
137	‚°
138
139	‚¹
140
141	_
142	½
143	_
144	_
145	‚
146	'
147	‚“
148	‚½
149	”½
150	‚
151	‚
152	‹“
153
154
155	‚
156
157	_
158	¾
159
160	‚
161	‚
162	‚
163	‚& pound ;
164	‚
165	‚
166	‚
167	‚§
168	‚
169	‚
170	‚
171	<<
172	‚
173	‚­
174	‚
175	‚
176	‚°
177	‚±
178	‚²
179	‚³
180	‚
181	‚µ
182	‚
183	‚·
184	‚
185	‚¹
186	‚
187	>>
188	‚¼
189	‚½
190	‚¾
191	‚
192	ƒ‚
193	ƒ½
194	ƒ
195	ƒ’
196	ƒ
197	ƒ
198	ƒ
199	ƒ
200	ƒ
201	ƒ°
202	ƒ
203	ƒ¹
204	ƒ’
205	ƒ½
206	ƒ½
207	ƒ½
208	ƒ½
209	ƒ˜
210	ƒ
211	ƒ
212	ƒ
213	ƒ
214	ƒ“
215	ƒ”
216	ƒ
217	ƒ
218	ƒ
219	ƒ
220	ƒ“
221	ƒ½
222	ƒ¾
223	ƒ
224	ƒ
225	ƒ
226	ƒ
227	ƒ
228	ƒ
229	ƒ
230	ƒ
231	Ĥ
232	ƒ
233	ƒ
234	ƒ
235	ƒ«
236	ƒ
237	ƒ­
238	ƒ
239	ƒ
240	ƒ°
241	ı
242	ƒ²
243	ƒ³
244	ƒ
245	ĵ
246	ƒ
247	ƒ·
248	ƒ
249	ƒ¹
250	ƒ
251	ƒ»
252	ƒ¼
253	ƒ½
254	ƒ¾
255	ƒ