This function translates a number into a string with the corresponding character.
Char (CharacterCode)
- CharacterCode (Required) - Character Code to translate
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) | ° |
