Excel CHAR Function (2 examples)

Excel CHAR Function

Excel CHAR function returns the character specified by a number. The excel CHAR function is used to translate code page numbers users might get from files on other types of computers into characters.

Example list:

---

1. How to use CHAR(10) as line breaker?
2. How to remove hidden space by using CHAR?
3. List of printable ASCII characters and codes

---

Syntax

CHAR(number)

where,

number: is the character code or the cell reference of the character code.

Example 1: CHAR(10) as line breaker:

The following image shows the use of CHAR(10) as line breaker. The formula is =B5&CHAR(10)&B6&CHAR(10)&B7, which returns the names in one cell with line break.

Example 2: Remove hidden space:

Suppose, we have hidden space in the cell B5. In the cell C5, we have use =TRIM(B5) and counted the number of characters in cell D5 with =LEN(C5). We found 30 as the number of characters.

To remove the hidden space, we use the formula =SUBSTITUTE(B5, CHAR(160), “”), and counted the number of characters in cell D6 by using the formula =LEN(C6) and found that the number of characters is 29, indicating that our formula has removed the hidden space.

Related posts:

MS Office post

TRIM Function

REPLACE Function

List of printable ASCII codes and their characters:

Serial Number	Character Symbol	Character Code	Character Name
1		32	Space
2	!	33	Exclamation mark
3	“	34	Double quotes (or speech marks)
4	#	35	Number
5	$	36	Dollar
6	%	37	Per cent sign
7	&	38	Ampersand
8	‘	39	Single quote
9	(	40	Open parenthesis (or open bracket)
10	)	41	Close parenthesis (or close bracket)
11	*	42	Asterisk
12	+	43	Plus
13	,	44	Comma
14	–	45	Hyphen
15	.	46	Period, dot or full stop
16	/	47	Slash or divide
17	0	48	Zero
18	1	49	One
19	2	50	Two
20	3	51	Three
21	4	52	Four
22	5	53	Five
23	6	54	Six
24	7	55	Seven
25	8	56	Eight
26	9	57	Nine
27	:	58	Colon
28	;	59	Semicolon
29	<	60	Less than (or open angled bracket)
30	=	61	Equals
31	>	62	Greater than (or close angled bracket)
32	?	63	Question mark
33	@	64	At symbol
34	A	65	Uppercase A
35	B	66	Uppercase B
36	C	67	Uppercase C
37	D	68	Uppercase D
38	E	69	Uppercase E
39	F	70	Uppercase F
40	G	71	Uppercase G
41	H	72	Uppercase H
42	I	73	Uppercase I
43	J	74	Uppercase J
44	K	75	Uppercase K
45	L	76	Uppercase L
46	M	77	Uppercase M
47	N	78	Uppercase N
48	O	79	Uppercase O
49	P	80	Uppercase P
50	Q	81	Uppercase Q
51	R	82	Uppercase R
52	S	83	Uppercase S
53	T	84	Uppercase T
54	U	85	Uppercase U
55	V	86	Uppercase V
56	W	87	Uppercase W
57	X	88	Uppercase X
58	Y	89	Uppercase Y
59	Z	90	Uppercase Z
60	[	91	Opening bracket
61	\	92	Backslash
62	]	93	Closing bracket
63	^	94	Caret – circumflex
64	_	95	Underscore
65	`	96	Grave accent
66	a	97	Lowercase a
67	b	98	Lowercase b
68	c	99	Lowercase c
69	d	100	Lowercase d
70	e	101	Lowercase e
71	f	102	Lowercase f
72	g	103	Lowercase g
73	h	104	Lowercase h
74	i	105	Lowercase i
75	j	106	Lowercase j
76	k	107	Lowercase k
77	l	108	Lowercase l
78	m	109	Lowercase m
79	n	110	Lowercase n
80	o	111	Lowercase o
81	p	112	Lowercase p
82	q	113	Lowercase q
83	r	114	Lowercase r
84	s	115	Lowercase s
85	t	116	Lowercase t
86	u	117	Lowercase u
87	v	118	Lowercase v
88	w	119	Lowercase w
89	x	120	Lowercase x
90	y	121	Lowercase y
91	z	122	Lowercase z
92	{	123	Opening brace
93	|	124	Vertical bar
94	}	125	Closing brace
95	~	126	Equivalency sign – tilde
96		127	Delete
97	€	128	Euro sign
98	‚	130	Latin small letter f with hook
99	ƒ	131	Double low-9 quotation mark
100	„	132	Horizontal ellipsis
101	…	133	Dagger
102	†	134	Double dagger
103	‡	135	Modifier letter circumflex accent
104	‰	137	Per mille sign
105	Š	138	Latin capital letter S with caron
106	‹	139	Single left-pointing angle quotation
107	Œ	140	Latin capital ligature OE
108	Ž	142	Latin capital letter Z with caron
109	‘	145	Left single quotation mark
110	’	146	Right single quotation mark
111	“	147	Left double quotation mark
112	”	148	Right double quotation mark
113	•	149	Bullet
114	–	150	En dash
115	—	151	Em dash
116	˜	152	Small tilde
117	™	153	Trademark sign
118	š	154	Latin small letter S with caron
119	›	155	Single right-pointing angle quotation mark
120	œ	156	Latin small ligature oe
121	ž	158	Latin small letter z with caron
122	Ÿ	159	Latin capital letter Y with diaeresis
123		160	Non-breaking space
124	¡	161	Inverted exclamation mark
125	¢	162	Cent sign
126	£	163	Pound sign
127	¤	164	Currency sign
128	¥	165	Yen sign
129	¦	166	Pipe, Broken vertical bar
130	§	167	Section sign
131	¨	168	Spacing diaeresis – umlaut
132	©	169	Copyright sign
133	ª	170	Feminine ordinal indicator
134	«	171	Left double angle quotes
135	¬	172	Not sign
136	­	173	Soft hyphen
137	®	174	Registered trade mark sign
138	¯	175	Spacing macron – overline
139	°	176	Degree sign
140	±	177	Plus-or-minus sign
141	²	178	Superscript two – squared
142	³	179	Superscript three – cubed
143	´	180	Acute accent – spacing acute
144	µ	181	Micro sign
145	¶	182	Pilcrow sign – paragraph sign
146	·	183	Middle dot – Georgian comma
147	¸	184	Spacing cedilla
148	¹	185	Superscript one
149	º	186	Masculine ordinal indicator
150	»	187	Right double angle quotes
151	¼	188	Fraction one quarter
152	½	189	Fraction one half
153	¾	190	Fraction three quarters
154	¿	191	Inverted question mark
155	À	192	Latin capital letter A with grave
156	Á	193	Latin capital letter A with acute
157	Â	194	Latin capital letter A with circumflex
158	Ã	195	Latin capital letter A with tilde
159	Ä	196	Latin capital letter A with diaeresis
160	Å	197	Latin capital letter A with ring above
161	Æ	198	Latin capital letter AE
162	Ç	199	Latin capital letter C with cedilla
163	È	200	Latin capital letter E with grave
164	É	201	Latin capital letter E with acute
165	Ê	202	Latin capital letter E with circumflex
166	Ë	203	Latin capital letter E with diaeresis
167	Ì	204	Latin capital letter I with grave
168	Í	205	Latin capital letter I with acute
169	Î	206	Latin capital letter I with circumflex
170	Ï	207	Latin capital letter I with diaeresis
171	Ð	208	Latin capital letter ETH
172	Ñ	209	Latin capital letter N with tilde
173	Ò	210	Latin capital letter O with grave
174	Ó	211	Latin capital letter O with acute
175	Ô	212	Latin capital letter O with circumflex
176	Õ	213	Latin capital letter O with tilde
177	Ö	214	Latin capital letter O with diaeresis
178	×	215	Multiplication sign
179	Ø	216	Latin capital letter O with slash
180	Ù	217	Latin capital letter U with grave
181	Ú	218	Latin capital letter U with acute
182	Û	219	Latin capital letter U with circumflex
183	Ü	220	Latin capital letter U with diaeresis
184	Ý	221	Latin capital letter Y with acute
185	Þ	222	Latin capital letter THORN
186	ß	223	Latin small letter sharp s – ess-zed
187	à	224	Latin small letter a with grave
188	á	225	Latin small letter a with acute
189	â	226	Latin small letter a with circumflex
190	ã	227	Latin small letter a with tilde
191	ä	228	Latin small letter a with diaeresis
192	å	229	Latin small letter a with ring above
193	æ	230	Latin small letter ae
194	ç	231	Latin small letter c with cedilla
195	è	232	Latin small letter e with grave
196	é	233	Latin small letter e with acute
197	ê	234	Latin small letter e with circumflex
198	ë	235	Latin small letter e with diaeresis
199	ì	236	Latin small letter i with grave
200	í	237	Latin small letter i with acute
201	î	238	Latin small letter i with circumflex
202	ï	239	Latin small letter i with diaeresis
203	ð	240	Latin small letter eth
204	ñ	241	Latin small letter n with tilde
205	ò	242	Latin small letter o with grave
206	ó	243	Latin small letter o with acute
207	ô	244	Latin small letter o with circumflex
208	õ	245	Latin small letter o with tilde
209	ö	246	Latin small letter o with diaeresis
210	÷	247	Division sign
211	ø	248	Latin small letter o with slash
212	ù	249	Latin small letter u with grave
213	ú	250	Latin small letter u with acute
214	û	251	Latin small letter u with circumflex
215	ü	252	Latin small letter u with diaeresis
216	ý	253	Latin small letter y with acute
217	þ	254	Latin small letter thorn
218	ÿ	255	Latin small letter y with diaeresis