CHAR EXCEL FORMULA

-
EXCEL FORMULA
Function Dictionary Function Examples Function Categories

CHAR

                                    
 
 
      ANSI Number Character
      65 A      =CHAR(G4)
      66 B      =CHAR(G5)
      169 ©      =CHAR(G6)
What Does It Do?                                
This function converts a normal number to the character it represent in the ANSI
character set used by Windows.
Syntax                                      
 =CHAR(Number)
 The Number must be between 1 and 255.
Formatting                                    
The result will be a character with no special formatting.
Example                                      
The following is a list of all 255 numbers and the characters they represent.
Note that most Windows based program may not display some of the special characters,
these  will be displayed as a small box.
1 26 51 3 76 L 101 e 126 ~ 151 — 176 ° 201 É 226 â 251 û
2 27 52 4 77 M 102 f 127  152 ˜ 177 ± 202 Ê 227 ã 252 ü
3 28 53 5 78 N 103 g 128 € 153 ™ 178 ² 203 Ë 228 ä 253 ý
4 29 54 6 79 O 104 h 129  154 š 179 ³ 204 Ì 229 å 254 þ
5 30 55 7 80 P 105 i 130 ‚ 155 › 180 ´ 205 Í 230 æ 255 ÿ
6 31 56 8 81 Q 106 j 131 ƒ 156 œ 181 µ 206 Î 231 ç
7 32   57 9 82 R 107 k 132 „ 157  182 207 Ï 232 è
8 33 ! 58 : 83 S 108 l 133 … 158 ž 183 · 208 Ð 233 é
9 34 " 59 ; 84 T 109 m 134 † 159 Ÿ 184 ¸ 209 Ñ 234 ê
10
35 # 60 < 85 U 110 n 135 ‡ 160   185 ¹ 210 Ò 235 ë
11
36 $ 61 = 86 V 111 o 136 ˆ 161 ¡ 186 º 211 Ó 236 ì
12 37 % 62 > 87 W 112 p 137 ‰ 162 ¢ 187 » 212 Ô 237 í
13
38 & 63 ? 88 X 113 q 138 Š 163 £ 188 ¼ 213 Õ 238 î
14 39 ' 64 @ 89 Y 114 r 139 ‹ 164 ¤ 189 ½ 214 Ö 239 ï
15 40 ( 65 A 90 Z 115 s 140 Œ 165 ¥ 190 ¾ 215 × 240 ð
16 41 ) 66 B 91 [ 116 t 141  166 ¦ 191 ¿ 216 Ø 241 ñ
17 42 * 67 C 92 \ 117 u 142 Ž 167 § 192 À 217 Ù 242 ò
18 43 + 68 D 93 ] 118 v 143  168 ¨ 193 Á 218 Ú 243 ó
19 44 , 69 E 94 ^ 119 w 144  169 © 194  219 Û 244 ô
20 45 - 70 F 95 _ 120 x 145 ‘ 170 ª 195 Ã 220 Ü 245 õ
21 46 . 71 G 96 ` 121 y 146 ’ 171 « 196 Ä 221 Ý 246 ö
22 47 / 72 H 97 a 122 z 147 “ 172 ¬ 197 Å 222 Þ 247 ÷
23 48 0 73 I 98 b 123 { 148 ” 173 ­ 198 Æ 223 ß 248 ø
24 49 1 74 J 99 c 124 | 149 • 174 ® 199 Ç 224 à 249 ù
25 50 2 75 K 100 d 125 } 150 – 175 ¯ 200 È 225 á 250 ú
Note                                        
Number 32 does not show as it is the SPACEBAR character.