.

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.

.

Popular posts from this blog

Tamilnadu SIXTH all books free download, Tamilnadu 6th all books free download

Tamilnadu FIRST STANDARD all books free download, Tamilnadu 1ST STANDARD all books free download