Char

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

Syntax

Char (CharacterCode)

  • CharacterCode (Required) - Character Code to translate

Common list of Characters in Excel

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)

°