Loading

Monday, 2 June 2014

CHAR Formula in MS Excel








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.





















No comments:

Post a Comment