The CHAR function returns a character specified by the code number from the character set for your computer.
For example, CHAR(34) returns a double quotation mark (“) and CHAR(10) returns a line break.
The full list can be accessed easily from within Excel by clicking on Insert, then selecting Symbol. In the Insert Symbol dialog, ensure the font is a normal Latin font (e.g. Arial and not Wingdings) and ensure “from” in the bottom right is set to ASCII (decimal):
Characters 1-32 represent system characters and aren’t displayed above. But as noted above, a useful character in this range is CHAR(10), which represents a line break.
The table below lists all codes from 32 to 255 (and 10!) Feel free to bookmark this page (by pressing Ctrl-D in Windows).
This list can also be downloaded here.
| Character Code | CHAR Function | Character Name | CHAR Symbol | Category |
| 10 | =CHAR(10) | Line Break | Example: Line Break |
Punctuation |
| 32 | =CHAR(32) | Space | Punctuation | |
| 33 | =CHAR(33) | Exclamation mark | ! | Punctuation |
| 34 | =CHAR(34) | Double quotes (or speech marks) | “ | Punctuation |
| 35 | =CHAR(35) | Number | # | Punctuation |
| 36 | =CHAR(36) | Dollar | $ | Punctuation |
| 37 | =CHAR(37) | Per cent sign | % | Punctuation |
| 38 | =CHAR(38) | Ampersand | & | Punctuation |
| 39 | =CHAR(39) | Single quote | ‘ | Punctuation |
| 40 | =CHAR(40) | Open parenthesis (or open bracket) | ( | Punctuation |
| 41 | =CHAR(41) | Close parenthesis (or close bracket) | ) | Punctuation |
| 42 | =CHAR(42) | Asterisk | * | Punctuation |
| 43 | =CHAR(43) | Plus | + | Punctuation |
| 44 | =CHAR(44) | Comma | , | Punctuation |
| 45 | =CHAR(45) | Hyphen | – | Punctuation |
| 46 | =CHAR(46) | Period, dot or full stop | . | Punctuation |
| 47 | =CHAR(47) | Slash or divide | / | Punctuation |
| 48 | =CHAR(48) | Zero | 0 | Numbers |
| 49 | =CHAR(49) | One | 1 | Numbers |
| 50 | =CHAR(50) | Two | 2 | Numbers |
| 51 | =CHAR(51) | Three | 3 | Numbers |
| 52 | =CHAR(52) | Four | 4 | Numbers |
| 53 | =CHAR(53) | Five | 5 | Numbers |
| 54 | =CHAR(54) | Six | 6 | Numbers |
| 55 | =CHAR(55) | Seven | 7 | Numbers |
| 56 | =CHAR(56) | Eight | 8 | Numbers |
| 57 | =CHAR(57) | Nine | 9 | Numbers |
| 58 | =CHAR(58) | Colon | : | Special Characters |
| 59 | =CHAR(59) | Semicolon | ; | Special Characters |
| 60 | =CHAR(60) | Less than (or open angled bracket) | < | Special Characters |
| 61 | =CHAR(61) | Equals | = | Special Characters |
| 62 | =CHAR(62) | Greater than (or close angled bracket) | > | Special Characters |
| 63 | =CHAR(63) | Question mark | ? | Special Characters |
| 64 | =CHAR(64) | At symbol | @ | Special Characters |
| 65 | =CHAR(65) | Uppercase A | A | Letters (Upper Case) |
| 66 | =CHAR(66) | Uppercase B | B | Letters (Upper Case) |
| 67 | =CHAR(67) | Uppercase C | C | Letters (Upper Case) |
| 68 | =CHAR(68) | Uppercase D | D | Letters (Upper Case) |
| 69 | =CHAR(69) | Uppercase E | E | Letters (Upper Case) |
| 70 | =CHAR(70) | Uppercase F | F | Letters (Upper Case) |
| 71 | =CHAR(71) | Uppercase G | G | Letters (Upper Case) |
| 72 | =CHAR(72) | Uppercase H | H | Letters (Upper Case) |
| 73 | =CHAR(73) | Uppercase I | I | Letters (Upper Case) |
| 74 | =CHAR(74) | Uppercase J | J | Letters (Upper Case) |
| 75 | =CHAR(75) | Uppercase K | K | Letters (Upper Case) |
| 76 | =CHAR(76) | Uppercase L | L | Letters (Upper Case) |
| 77 | =CHAR(77) | Uppercase M | M | Letters (Upper Case) |
| 78 | =CHAR(78) | Uppercase N | N | Letters (Upper Case) |
| 79 | =CHAR(79) | Uppercase O | O | Letters (Upper Case) |
| 80 | =CHAR(80) | Uppercase P | P | Letters (Upper Case) |
| 81 | =CHAR(81) | Uppercase Q | Q | Letters (Upper Case) |
| 82 | =CHAR(82) | Uppercase R | R | Letters (Upper Case) |
| 83 | =CHAR(83) | Uppercase S | S | Letters (Upper Case) |
| 84 | =CHAR(84) | Uppercase T | T | Letters (Upper Case) |
| 85 | =CHAR(85) | Uppercase U | U | Letters (Upper Case) |
| 86 | =CHAR(86) | Uppercase V | V | Letters (Upper Case) |
| 87 | =CHAR(87) | Uppercase W | W | Letters (Upper Case) |
| 88 | =CHAR(88) | Uppercase X | X | Letters (Upper Case) |
| 89 | =CHAR(89) | Uppercase Y | Y | Letters (Upper Case) |
| 90 | =CHAR(90) | Uppercase Z | Z | Letters (Upper Case) |
| 91 | =CHAR(91) | Opening bracket | [ | Special Characters |
| 92 | =CHAR(92) | Backslash | \ | Special Characters |
| 93 | =CHAR(93) | Closing bracket | ] | Special Characters |
| 94 | =CHAR(94) | Caret – circumflex | ^ | Special Characters |
| 95 | =CHAR(95) | Underscore | _ | Special Characters |
| 96 | =CHAR(96) | Grave accent | ` | Special Characters |
| 97 | =CHAR(97) | Lowercase a | a | Letters (Lower Case) |
| 98 | =CHAR(98) | Lowercase b | b | Letters (Lower Case) |
| 99 | =CHAR(99) | Lowercase c | c | Letters (Lower Case) |
| 100 | =CHAR(100) | Lowercase d | d | Letters (Lower Case) |
| 101 | =CHAR(101) | Lowercase e | e | Letters (Lower Case) |
| 102 | =CHAR(102) | Lowercase f | f | Letters (Lower Case) |
| 103 | =CHAR(103) | Lowercase g | g | Letters (Lower Case) |
| 104 | =CHAR(104) | Lowercase h | h | Letters (Lower Case) |
| 105 | =CHAR(105) | Lowercase i | i | Letters (Lower Case) |
| 106 | =CHAR(106) | Lowercase j | j | Letters (Lower Case) |
| 107 | =CHAR(107) | Lowercase k | k | Letters (Lower Case) |
| 108 | =CHAR(108) | Lowercase l | l | Letters (Lower Case) |
| 109 | =CHAR(109) | Lowercase m | m | Letters (Lower Case) |
| 110 | =CHAR(110) | Lowercase n | n | Letters (Lower Case) |
| 111 | =CHAR(111) | Lowercase o | o | Letters (Lower Case) |
| 112 | =CHAR(112) | Lowercase p | p | Letters (Lower Case) |
| 113 | =CHAR(113) | Lowercase q | q | Letters (Lower Case) |
| 114 | =CHAR(114) | Lowercase r | r | Letters (Lower Case) |
| 115 | =CHAR(115) | Lowercase s | s | Letters (Lower Case) |
| 116 | =CHAR(116) | Lowercase t | t | Letters (Lower Case) |
| 117 | =CHAR(117) | Lowercase u | u | Letters (Lower Case) |
| 118 | =CHAR(118) | Lowercase v | v | Letters (Lower Case) |
| 119 | =CHAR(119) | Lowercase w | w | Letters (Lower Case) |
| 120 | =CHAR(120) | Lowercase x | x | Letters (Lower Case) |
| 121 | =CHAR(121) | Lowercase y | y | Letters (Lower Case) |
| 122 | =CHAR(122) | Lowercase z | z | Letters (Lower Case) |
| 123 | =CHAR(123) | Opening brace | { | Special Characters |
| 124 | =CHAR(124) | Vertical bar | | | Special Characters |
| 125 | =CHAR(125) | Closing brace | } | Special Characters |
| 126 | =CHAR(126) | Equivalency sign – tilde | ~ | Special Characters |
| 127 | =CHAR(127) | Delete | | Special Characters |
| 128 | =CHAR(128) | Euro sign | € | Special Characters |
| 130 | =CHAR(130) | Latin small letter f with hook | ‚ | Special Characters |
| 131 | =CHAR(131) | Double low-9 quotation mark | ƒ | Special Characters |
| 132 | =CHAR(132) | Horizontal ellipsis | „ | Special Characters |
| 133 | =CHAR(133) | Dagger | … | Special Characters |
| 134 | =CHAR(134) | Double dagger | † | Special Characters |
| 135 | =CHAR(135) | Modifier letter circumflex accent | ‡ | Special Characters |
| 137 | =CHAR(137) | Per mille sign | ‰ | Special Characters |
| 138 | =CHAR(138) | Latin capital letter S with caron | Š | Special Characters |
| 139 | =CHAR(139) | Single left-pointing angle quotation | ‹ | Special Characters |
| 140 | =CHAR(140) | Latin capital ligature OE | Π| Special Characters |
| 142 | =CHAR(142) | Latin capital letter Z with caron | Ž | Special Characters |
| 145 | =CHAR(145) | Left single quotation mark | ‘ | Special Characters |
| 146 | =CHAR(146) | Right single quotation mark | ’ | Special Characters |
| 147 | =CHAR(147) | Left double quotation mark | “ | Special Characters |
| 148 | =CHAR(148) | Right double quotation mark | ” | Special Characters |
| 149 | =CHAR(149) | Bullet | • | Special Characters |
| 150 | =CHAR(150) | En dash | – | Special Characters |
| 151 | =CHAR(151) | Em dash | — | Special Characters |
| 152 | =CHAR(152) | Small tilde | ˜ | Special Characters |
| 153 | =CHAR(153) | Trade mark sign | ™ | Special Characters |
| 154 | =CHAR(154) | Latin small letter S with caron | š | Special Characters |
| 155 | =CHAR(155) | Single right-pointing angle quotation mark | › | Special Characters |
| 156 | =CHAR(156) | Latin small ligature oe | œ | Special Characters |
| 158 | =CHAR(158) | Latin small letter z with caron | ž | Special Characters |
| 159 | =CHAR(159) | Latin capital letter Y with diaeresis | Ÿ | Special Characters |
| 160 | =CHAR(160) | Non-breaking space | Special Characters | |
| 161 | =CHAR(161) | Inverted exclamation mark | ¡ | Special Characters |
| 162 | =CHAR(162) | Cent sign | ¢ | Special Characters |
| 163 | =CHAR(163) | Pound sign | £ | Special Characters |
| 164 | =CHAR(164) | Currency sign | ¤ | Special Characters |
| 165 | =CHAR(165) | Yen sign | ¥ | Special Characters |
| 166 | =CHAR(166) | Pipe, Broken vertical bar | ¦ | Special Characters |
| 167 | =CHAR(167) | Section sign | § | Special Characters |
| 168 | =CHAR(168) | Spacing diaeresis – umlaut | ¨ | Special Characters |
| 169 | =CHAR(169) | Copyright sign | © | Special Characters |
| 170 | =CHAR(170) | Feminine ordinal indicator | ª | Special Characters |
| 171 | =CHAR(171) | Left double angle quotes | « | Special Characters |
| 172 | =CHAR(172) | Not sign | ¬ | Special Characters |
| 173 | =CHAR(173) | Soft hyphen | | Special Characters |
| 174 | =CHAR(174) | Registered trade mark sign | ® | Special Characters |
| 175 | =CHAR(175) | Spacing macron – overline | ¯ | Special Characters |
| 176 | =CHAR(176) | Degree sign | ° | Special Characters |
| 177 | =CHAR(177) | Plus-or-minus sign | ± | Special Characters |
| 178 | =CHAR(178) | Superscript two – squared | ² | Special Characters |
| 179 | =CHAR(179) | Superscript three – cubed | ³ | Special Characters |
| 180 | =CHAR(180) | Acute accent – spacing acute | ´ | Special Characters |
| 181 | =CHAR(181) | Micro sign | µ | Special Characters |
| 182 | =CHAR(182) | Pilcrow sign – paragraph sign | ¶ | Special Characters |
| 183 | =CHAR(183) | Middle dot – Georgian comma | · | Special Characters |
| 184 | =CHAR(184) | Spacing cedilla | ¸ | Special Characters |
| 185 | =CHAR(185) | Superscript one | ¹ | Special Characters |
| 186 | =CHAR(186) | Masculine ordinal indicator | º | Special Characters |
| 187 | =CHAR(187) | Right double angle quotes | » | Special Characters |
| 188 | =CHAR(188) | Fraction one quarter | ¼ | Special Characters |
| 189 | =CHAR(189) | Fraction one half | ½ | Special Characters |
| 190 | =CHAR(190) | Fraction three quarters | ¾ | Special Characters |
| 191 | =CHAR(191) | Inverted question mark | ¿ | Special Characters |
| 192 | =CHAR(192) | Latin capital letter A with grave | À | Upper Case Latin-1 Letters |
| 193 | =CHAR(193) | Latin capital letter A with acute | Á | Upper Case Latin-1 Letters |
| 194 | =CHAR(194) | Latin capital letter A with circumflex | Â | Upper Case Latin-1 Letters |
| 195 | =CHAR(195) | Latin capital letter A with tilde | Ã | Upper Case Latin-1 Letters |
| 196 | =CHAR(196) | Latin capital letter A with diaeresis | Ä | Upper Case Latin-1 Letters |
| 197 | =CHAR(197) | Latin capital letter A with ring above | Å | Upper Case Latin-1 Letters |
| 198 | =CHAR(198) | Latin capital letter AE | Æ | Upper Case Latin-1 Letters |
| 199 | =CHAR(199) | Latin capital letter C with cedilla | Ç | Upper Case Latin-1 Letters |
| 200 | =CHAR(200) | Latin capital letter E with grave | È | Upper Case Latin-1 Letters |
| 201 | =CHAR(201) | Latin capital letter E with acute | É | Upper Case Latin-1 Letters |
| 202 | =CHAR(202) | Latin capital letter E with circumflex | Ê | Upper Case Latin-1 Letters |
| 203 | =CHAR(203) | Latin capital letter E with diaeresis | Ë | Upper Case Latin-1 Letters |
| 204 | =CHAR(204) | Latin capital letter I with grave | Ì | Upper Case Latin-1 Letters |
| 205 | =CHAR(205) | Latin capital letter I with acute | Í | Upper Case Latin-1 Letters |
| 206 | =CHAR(206) | Latin capital letter I with circumflex | Î | Upper Case Latin-1 Letters |
| 207 | =CHAR(207) | Latin capital letter I with diaeresis | Ï | Upper Case Latin-1 Letters |
| 208 | =CHAR(208) | Latin capital letter ETH | Ð | Upper Case Latin-1 Letters |
| 209 | =CHAR(209) | Latin capital letter N with tilde | Ñ | Upper Case Latin-1 Letters |
| 210 | =CHAR(210) | Latin capital letter O with grave | Ò | Upper Case Latin-1 Letters |
| 211 | =CHAR(211) | Latin capital letter O with acute | Ó | Upper Case Latin-1 Letters |
| 212 | =CHAR(212) | Latin capital letter O with circumflex | Ô | Upper Case Latin-1 Letters |
| 213 | =CHAR(213) | Latin capital letter O with tilde | Õ | Upper Case Latin-1 Letters |
| 214 | =CHAR(214) | Latin capital letter O with diaeresis | Ö | Upper Case Latin-1 Letters |
| 215 | =CHAR(215) | Multiplication sign | × | Upper Case Latin-1 Letters |
| 216 | =CHAR(216) | Latin capital letter O with slash | Ø | Upper Case Latin-1 Letters |
| 217 | =CHAR(217) | Latin capital letter U with grave | Ù | Upper Case Latin-1 Letters |
| 218 | =CHAR(218) | Latin capital letter U with acute | Ú | Upper Case Latin-1 Letters |
| 219 | =CHAR(219) | Latin capital letter U with circumflex | Û | Upper Case Latin-1 Letters |
| 220 | =CHAR(220) | Latin capital letter U with diaeresis | Ü | Upper Case Latin-1 Letters |
| 221 | =CHAR(221) | Latin capital letter Y with acute | Ý | Upper Case Latin-1 Letters |
| 222 | =CHAR(222) | Latin capital letter THORN | Þ | Upper Case Latin-1 Letters |
| 223 | =CHAR(223) | Latin small letter sharp s – ess-zed | ß | Lower Case Latin-1 Letters |
| 224 | =CHAR(224) | Latin small letter a with grave | à | Lower Case Latin-1 Letters |
| 225 | =CHAR(225) | Latin small letter a with acute | á | Lower Case Latin-1 Letters |
| 226 | =CHAR(226) | Latin small letter a with circumflex | â | Lower Case Latin-1 Letters |
| 227 | =CHAR(227) | Latin small letter a with tilde | ã | Lower Case Latin-1 Letters |
| 228 | =CHAR(228) | Latin small letter a with diaeresis | ä | Lower Case Latin-1 Letters |
| 229 | =CHAR(229) | Latin small letter a with ring above | å | Lower Case Latin-1 Letters |
| 230 | =CHAR(230) | Latin small letter ae | æ | Lower Case Latin-1 Letters |
| 231 | =CHAR(231) | Latin small letter c with cedilla | ç | Lower Case Latin-1 Letters |
| 232 | =CHAR(232) | Latin small letter e with grave | è | Lower Case Latin-1 Letters |
| 233 | =CHAR(233) | Latin small letter e with acute | é | Lower Case Latin-1 Letters |
| 234 | =CHAR(234) | Latin small letter e with circumflex | ê | Lower Case Latin-1 Letters |
| 235 | =CHAR(235) | Latin small letter e with diaeresis | ë | Lower Case Latin-1 Letters |
| 236 | =CHAR(236) | Latin small letter i with grave | ì | Lower Case Latin-1 Letters |
| 237 | =CHAR(237) | Latin small letter i with acute | í | Lower Case Latin-1 Letters |
| 238 | =CHAR(238) | Latin small letter i with circumflex | î | Lower Case Latin-1 Letters |
| 239 | =CHAR(239) | Latin small letter i with diaeresis | ï | Lower Case Latin-1 Letters |
| 240 | =CHAR(240) | Latin small letter eth | ð | Lower Case Latin-1 Letters |
| 241 | =CHAR(241) | Latin small letter n with tilde | ñ | Lower Case Latin-1 Letters |
| 242 | =CHAR(242) | Latin small letter o with grave | ò | Lower Case Latin-1 Letters |
| 243 | =CHAR(243) | Latin small letter o with acute | ó | Lower Case Latin-1 Letters |
| 244 | =CHAR(244) | Latin small letter o with circumflex | ô | Lower Case Latin-1 Letters |
| 245 | =CHAR(245) | Latin small letter o with tilde | õ | Lower Case Latin-1 Letters |
| 246 | =CHAR(246) | Latin small letter o with diaeresis | ö | Lower Case Latin-1 Letters |
| 247 | =CHAR(247) | Division sign | ÷ | Lower Case Latin-1 Letters |
| 248 | =CHAR(248) | Latin small letter o with slash | ø | Lower Case Latin-1 Letters |
| 249 | =CHAR(249) | Latin small letter u with grave | ù | Lower Case Latin-1 Letters |
| 250 | =CHAR(250) | Latin small letter u with acute | ú | Lower Case Latin-1 Letters |
| 251 | =CHAR(251) | Latin small letter u with circumflex | û | Lower Case Latin-1 Letters |
| 252 | =CHAR(252) | Latin small letter u with diaeresis | ü | Lower Case Latin-1 Letters |
| 253 | =CHAR(253) | Latin small letter y with acute | ý | Lower Case Latin-1 Letters |
| 254 | =CHAR(254) | Latin small letter thorn | þ | Lower Case Latin-1 Letters |
| 255 | =CHAR(255) | Latin small letter y with diaeresis | ÿ | Lower Case Latin-1 Letters |
Not sure how to actually use the CHAR function? Find out here.
P.S. Make your life easier….
Haven’t discovered the wonders of PivotTables yet? Then it’s time you check out the 10 Steps to PivotTable Success. Time is money! So stop wasting time on repetitive analysis tasks that can be automated in a flash.
Ӏ know this if off toрic but I’m looking intο starting my ⲟѡn blog and was curious what all is required to get set up?
I’m assumіng haѵing a blog like yours would cost a pretty penny?
I’m not very web savvy so I’m not 100% sure. Any tips or advice
would be greatly appreciated. Thanks