Char

This function translates a number into a string with the corresponding character.

Syntax

Char (CharacterCode)

Here is a common list of Characters in Excel. This Char list is created using the Char function.

Character Code	Character Name	Char Function	Char Symbol
13	Line break	=Char(13)
32	Space	=Char(32)
33	Exclamation mark	=Char(33)	!
34	Double quotes (or speech marks)	=Char(34)	"
35	Number	=Char(35)
36	Dollar	=Char(36)	$
37	Percent Sign	=Char(37)	%
38	Ampersand	=Char(38)	&
39	Single quote	=Char(39)	'
40	Open parenthesis (or open bracket)	=Char(40)	(
41	Close parenthesis (or close bracket	=Char(41)	)
42	Asterisk	=Char(42)
43	Plus	=Char(43)
44	Comma	=Char(44)	,
45	Hyphen	=Char(45)
46	Period	=Char(46)	.
47	Slash	=Char(47)	/
48	Zero	=Char(48)	0
49	One	=Char(49)	1
50	Two	=Char(50)	2
51	Three	=Char(51)	3
52	Four	=Char(52)	4
53	Five	=Char(53)	5
54	Six	=Char(54)	6
55	Seven	=Char(55)	7
56	Eight	=Char(56)	8
57	Nine	=Char(57)	9
58	Colon	=Char(58)	:
59	Semicolon	=Char(59)	;
60	Less than	=Char(60)	<
61	Equals	=Char(61)	=
62	Greater than	=Char(62)	>
63	Question mark	=Char(63)	?
64	At symbol	=Char(64)	@
176	degree symbol	=Char(176)	°