CHAR EXCEL FORMULA

EXCEL FORMULA
Function Dictionary	Function Examples	Function Categories

CHAR
						ANSI Number	Character
						65	A				=CHAR(G4)
						66	B				=CHAR(G5)
						169	©				=CHAR(G6)
	What Does It Do?
	This function converts a normal number to the character it represent in the ANSI
	character set used by Windows.
	Syntax
	=CHAR(Number)
	The Number must be between 1 and 255.
	Formatting
	The result will be a character with no special formatting.
	Example
	The following is a list of all 255 numbers and the characters they represent.
	Note that most Windows based program may not display some of the special characters,
	these  will be displayed as a small box.
	1		26		51	3	76	L	101	e	126	~	151	—	176	°	201	É	226	â	251	û
	2		27		52	4	77	M	102	f	127		152	˜	177	±	202	Ê	227	ã	252	ü
	3		28		53	5	78	N	103	g	128	€	153	™	178	²	203	Ë	228	ä	253	ý
	4		29		54	6	79	O	104	h	129		154	š	179	³	204	Ì	229	å	254	þ
	5		30		55	7	80	P	105	i	130	‚	155	›	180	´	205	Í	230	æ	255	ÿ
	6		31		56	8	81	Q	106	j	131	ƒ	156	œ	181	µ	206	Î	231	ç
	7		32		57	9	82	R	107	k	132	„	157		182	¶	207	Ï	232	è
	8		33	!	58	:	83	S	108	l	133	…	158	ž	183	·	208	Ð	233	é
	9		34	"	59	;	84	T	109	m	134	†	159	Ÿ	184	¸	209	Ñ	234	ê
	10		35	#	60	<	85	U	110	n	135	‡	160		185	¹	210	Ò	235	ë
	11		36	$	61	=	86	V	111	o	136	ˆ	161	¡	186	º	211	Ó	236	ì
	12		37	%	62	>	87	W	112	p	137	‰	162	¢	187	»	212	Ô	237	í
	13		38	&	63	?	88	X	113	q	138	Š	163	£	188	¼	213	Õ	238	î
	14		39	'	64	@	89	Y	114	r	139	‹	164	¤	189	½	214	Ö	239	ï
	15		40	(	65	A	90	Z	115	s	140	Œ	165	¥	190	¾	215	×	240	ð
	16		41	)	66	B	91	[	116	t	141		166	¦	191	¿	216	Ø	241	ñ
	17		42	*	67	C	92	\	117	u	142	Ž	167	§	192	À	217	Ù	242	ò
	18		43	+	68	D	93	]	118	v	143		168	¨	193	Á	218	Ú	243	ó
	19		44	,	69	E	94	^	119	w	144		169	©	194	Â	219	Û	244	ô
	20		45	-	70	F	95	_	120	x	145	‘	170	ª	195	Ã	220	Ü	245	õ
	21		46	.	71	G	96	`	121	y	146	’	171	«	196	Ä	221	Ý	246	ö
	22		47	/	72	H	97	a	122	z	147	“	172	¬	197	Å	222	Þ	247	÷
	23		48	0	73	I	98	b	123	{	148	”	173	­	198	Æ	223	ß	248	ø
	24		49	1	74	J	99	c	124	|	149	•	174	®	199	Ç	224	à	249	ù
	25		50	2	75	K	100	d	125	}	150	–	175	¯	200	È	225	á	250	ú
	Note
	Number 32 does not show as it is the SPACEBAR character.