CLEAN

	Dirty Text	Clean Text
	Hello	Hello	=CLEAN(C4)
	Hello	Hello	=CLEAN(C5)
	Hello	Hello	=CLEAN(C6)
What Does It Do?
This function removes any nonprintable characters from text.
These nonprinting characters are often found in data which has been imported
from other systems such as database imports from mainframes.
Syntax
=CLEAN(TextToBeCleaned)
Formatting
No special formatting is needed. The result will show as normal text.

CHOOSE

	Index Value	Result
	1	Alan	=CHOOSE(C4,"Alan","Bob","Carol")
	3	Carol	=CHOOSE(C5,"Alan","Bob","Carol")
	2	Bob	=CHOOSE(C6,"Alan","Bob","Carol")
	3	18%	=CHOOSE(C7,10%,15%,18%)
	1	10%	=CHOOSE(C8,10%,15%,18%)
	2	15%	=CHOOSE(C9,10%,15%,18%)
What Does It Do?
This function picks from a list of options based upon an Index value given to by the user.
Syntax
=CHOOSE(UserValue, Item1, Item2, Item3 through to Item29)
Formatting
No special formatting is required.
Example
The following table was used to calculate the medals for athletes taking part in a race.
The Time for each athlete is entered.
The =RANK() function calculates the finishing position of each athlete.
The =CHOOSE() then allocates the correct medal.
The =IF() has been used to filter out any positions above 3, as this would cause
the error of #VALUE to appear, due to the fact the =CHOOSE() has only three items in it.
Name	Time	Position	Medal
Alan	1:30	2	Silver	=IF(D30<=3,CHOOSE(D30,"Gold","Silver","Bronze"),"unplaced")
Bob	1:15	4	unplaced	=IF(D31<=3,CHOOSE(D31,"Gold","Silver","Bronze"),"unplaced")
Carol	2:45	1	Gold	=IF(D32<=3,CHOOSE(D32,"Gold","Silver","Bronze"),"unplaced")
David	1:05	5	unplaced	=IF(D33<=3,CHOOSE(D33,"Gold","Silver","Bronze"),"unplaced")
Eric	1:20	3	Bronze	=IF(D34<=3,CHOOSE(D34,"Gold","Silver","Bronze"),"unplaced")
		=RANK(C34,C30:C34)

CHAR

ANSI Number

Character

65

A

=CHAR(G4)

66

B

=CHAR(G5)

##

©

=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	##	d	125	}	150	–	175	¯	200	È	225	á	250	ú

Note

Number 32 does not show as it is the SPACEBAR character.