Case sensitivity in excel

[Guy Fawkes]

Another daft question . . .

Is there any way excel can differentiate between, for example, 'W' and 'w'.

E.g.

=if(a1="W",5,if(a1="w",3,0))

Cheers.

[GotaFancy?]

Yes - you can take the ASCII value ... can't remember what the command is though ..... one sec.....

[GotaFancy?]

Assuming you have your w or W in cell B5, the formula below should work

=IF(CODE(B5)=87,5,IF(CODE(B5)=119,3,0))

To find out the ASCII value of something (e.g. "x"), just type =CODE("x") into Excel

[Guy Fawkes]

Originally Posted by GotaFancy?

Assuming you have your w or W in cell B5, the formula below should work

=IF(CODE(B5)=87,5,IF(CODE(B5)=119,3,0))

To find out the ASCII value of something (e.g. "x"), just type =CODE("x") into Excel

GaF,

You are an absolute star, cheers so much mate.

[Trilobite]

readable ASCII

Decimal - 33 = Hex - 21 = Character - !
Decimal - 34 = Hex - 22 = Character - "
Decimal - 35 = Hex - 23 = Character - #
Decimal - 36 = Hex - 24 = Character - $
Decimal - 37 = Hex - 25 = Character - %
Decimal - 38 = Hex - 26 = Character - &
Decimal - 39 = Hex - 27 = Character - '
Decimal - 40 = Hex - 28 = Character - (
Decimal - 41 = Hex - 29 = Character - )
Decimal - 42 = Hex - 2A = Character - *
Decimal - 43 = Hex - 2B = Character - +
Decimal - 44 = Hex - 2C = Character - ,
Decimal - 45 = Hex - 2D = Character - -
Decimal - 46 = Hex - 2E = Character - .
Decimal - 47 = Hex - 2F = Character - /
Decimal - 48 = Hex - 30 = Character - 0
Decimal - 49 = Hex - 31 = Character - 1
Decimal - 50 = Hex - 32 = Character - 2
Decimal - 51 = Hex - 33 = Character - 3
Decimal - 52 = Hex - 34 = Character - 4
Decimal - 53 = Hex - 35 = Character - 5
Decimal - 54 = Hex - 36 = Character - 6
Decimal - 55 = Hex - 37 = Character - 7
Decimal - 56 = Hex - 38 = Character - 8
Decimal - 57 = Hex - 39 = Character - 9
Decimal - 58 = Hex - 3A = Character - :
Decimal - 59 = Hex - 3B = Character - ;
Decimal - 60 = Hex - 3C = Character - <
Decimal - 61 = Hex - 3D = Character - =
Decimal - 62 = Hex - 3E = Character - >
Decimal - 63 = Hex - 3F = Character - ?
Decimal - 64 = Hex - 40 = Character - @
Decimal - 65 = Hex - 41 = Character - A
Decimal - 66 = Hex - 42 = Character - B
Decimal - 67 = Hex - 43 = Character - C
Decimal - 68 = Hex - 44 = Character - D
Decimal - 69 = Hex - 45 = Character - E
Decimal - 70 = Hex - 46 = Character - F
Decimal - 71 = Hex - 47 = Character - G
Decimal - 72 = Hex - 48 = Character - H
Decimal - 73 = Hex - 49 = Character - I
Decimal - 74 = Hex - 4A = Character - J
Decimal - 75 = Hex - 4B = Character - K
Decimal - 76 = Hex - 4C = Character - L
Decimal - 77 = Hex - 4D = Character - M
Decimal - 78 = Hex - 4E = Character - N
Decimal - 79 = Hex - 4F = Character - O
Decimal - 80 = Hex - 50 = Character - P
Decimal - 81 = Hex - 51 = Character - Q
Decimal - 82 = Hex - 52 = Character - R
Decimal - 83 = Hex - 53 = Character - S
Decimal - 84 = Hex - 54 = Character - T
Decimal - 85 = Hex - 55 = Character - U
Decimal - 86 = Hex - 56 = Character - V
Decimal - 87 = Hex - 57 = Character - W
Decimal - 88 = Hex - 58 = Character - X
Decimal - 89 = Hex - 59 = Character - Y
Decimal - 90 = Hex - 5A = Character - Z
Decimal - 91 = Hex - 5B = Character - [
Decimal - 92 = Hex - 5C = Character - \
Decimal - 93 = Hex - 5D = Character - ]
Decimal - 94 = Hex - 5E = Character - ^
Decimal - 95 = Hex - 5F = Character - _
Decimal - 96 = Hex - 60 = Character - `
Decimal - 97 = Hex - 61 = Character - a
Decimal - 98 = Hex - 62 = Character - b
Decimal - 99 = Hex - 63 = Character - c
Decimal - 100 = Hex - 64 = Character - d
Decimal - 101 = Hex - 65 = Character - e
Decimal - 102 = Hex - 66 = Character - f
Decimal - 103 = Hex - 67 = Character - g
Decimal - 104 = Hex - 68 = Character - h
Decimal - 105 = Hex - 69 = Character - i
Decimal - 106 = Hex - 6A = Character - j
Decimal - 107 = Hex - 6B = Character - k
Decimal - 108 = Hex - 6C = Character - l
Decimal - 109 = Hex - 6D = Character - m
Decimal - 110 = Hex - 6E = Character - n
Decimal - 111 = Hex - 6F = Character - o
Decimal - 112 = Hex - 70 = Character - p
Decimal - 113 = Hex - 71 = Character - q
Decimal - 114 = Hex - 72 = Character - r
Decimal - 115 = Hex - 73 = Character - s
Decimal - 116 = Hex - 74 = Character - t
Decimal - 117 = Hex - 75 = Character - u
Decimal - 118 = Hex - 76 = Character - v
Decimal - 119 = Hex - 77 = Character - w
Decimal - 120 = Hex - 78 = Character - x
Decimal - 121 = Hex - 79 = Character - y
Decimal - 122 = Hex - 7A = Character - z
Decimal - 123 = Hex - 7B = Character - {
Decimal - 124 = Hex - 7C = Character - |
Decimal - 125 = Hex - 7D = Character - }
Decimal - 126 = Hex - 7E = Character - ~
Decimal - 127 = Hex - 7F = Character - 
Decimal - 128 = Hex - 80 = Character - €
Decimal - 129 = Hex - 81 = Character - �
Decimal - 130 = Hex - 82 = Character - ‚
Decimal - 131 = Hex - 83 = Character - ƒ
Decimal - 132 = Hex - 84 = Character - „
Decimal - 133 = Hex - 85 = Character - …
Decimal - 134 = Hex - 86 = Character - †
Decimal - 135 = Hex - 87 = Character - ‡
Decimal - 136 = Hex - 88 = Character - ˆ
Decimal - 137 = Hex - 89 = Character - ‰
Decimal - 138 = Hex - 8A = Character - Š
Decimal - 139 = Hex - 8B = Character - ‹
Decimal - 140 = Hex - 8C = Character - Œ
Decimal - 141 = Hex - 8D = Character - �
Decimal - 142 = Hex - 8E = Character - Ž
Decimal - 143 = Hex - 8F = Character - �
Decimal - 144 = Hex - 90 = Character - �
Decimal - 145 = Hex - 91 = Character - ‘
Decimal - 146 = Hex - 92 = Character - ’
Decimal - 147 = Hex - 93 = Character - “
Decimal - 148 = Hex - 94 = Character - ”
Decimal - 149 = Hex - 95 = Character - •
Decimal - 150 = Hex - 96 = Character - –
Decimal - 151 = Hex - 97 = Character - —
Decimal - 152 = Hex - 98 = Character - ˜
Decimal - 153 = Hex - 99 = Character - ™
Decimal - 154 = Hex - 9A = Character - š
Decimal - 155 = Hex - 9B = Character - ›
Decimal - 156 = Hex - 9C = Character - œ
Decimal - 157 = Hex - 9D = Character - �
Decimal - 158 = Hex - 9E = Character - ž
Decimal - 159 = Hex - 9F = Character - Ÿ
Decimal - 160 = Hex - A0 = Character - *
Decimal - 161 = Hex - A1 = Character - ¡
Decimal - 162 = Hex - A2 = Character - ¢
Decimal - 163 = Hex - A3 = Character - £
Decimal - 164 = Hex - A4 = Character - ¤
Decimal - 165 = Hex - A5 = Character - ¥
Decimal - 166 = Hex - A6 = Character - ¦
Decimal - 167 = Hex - A7 = Character - §
Decimal - 168 = Hex - A8 = Character - ¨
Decimal - 169 = Hex - A9 = Character - ©
Decimal - 170 = Hex - AA = Character - ª
Decimal - 171 = Hex - AB = Character - «
Decimal - 172 = Hex - AC = Character - ¬
Decimal - 173 = Hex - AD = Character - *
Decimal - 174 = Hex - AE = Character - ®
Decimal - 175 = Hex - AF = Character - ¯
Decimal - 176 = Hex - B0 = Character - °
Decimal - 177 = Hex - B1 = Character - ±
Decimal - 178 = Hex - B2 = Character - ²
Decimal - 179 = Hex - B3 = Character - ³
Decimal - 180 = Hex - B4 = Character - ´
Decimal - 181 = Hex - B5 = Character - µ
Decimal - 182 = Hex - B6 = Character - ¶
Decimal - 183 = Hex - B7 = Character - ·
Decimal - 184 = Hex - B8 = Character - ¸
Decimal - 185 = Hex - B9 = Character - ¹
Decimal - 186 = Hex - BA = Character - º
Decimal - 187 = Hex - BB = Character - »
Decimal - 188 = Hex - BC = Character - ¼
Decimal - 189 = Hex - BD = Character - ½
Decimal - 190 = Hex - BE = Character - ¾
Decimal - 191 = Hex - BF = Character - ¿
Decimal - 192 = Hex - C0 = Character - À
Decimal - 193 = Hex - C1 = Character - Á
Decimal - 194 = Hex - C2 = Character - Â
Decimal - 195 = Hex - C3 = Character - Ã
Decimal - 196 = Hex - C4 = Character - Ä
Decimal - 197 = Hex - C5 = Character - Å
Decimal - 198 = Hex - C6 = Character - Æ
Decimal - 199 = Hex - C7 = Character - Ç
Decimal - 200 = Hex - C8 = Character - È
Decimal - 201 = Hex - C9 = Character - É
Decimal - 202 = Hex - CA = Character - Ê
Decimal - 203 = Hex - CB = Character - Ë
Decimal - 204 = Hex - CC = Character - Ì
Decimal - 205 = Hex - CD = Character - Í
Decimal - 206 = Hex - CE = Character - Î
Decimal - 207 = Hex - CF = Character - Ï
Decimal - 208 = Hex - D0 = Character - Ð
Decimal - 209 = Hex - D1 = Character - Ñ
Decimal - 210 = Hex - D2 = Character - Ò
Decimal - 211 = Hex - D3 = Character - Ó
Decimal - 212 = Hex - D4 = Character - Ô
Decimal - 213 = Hex - D5 = Character - Õ
Decimal - 214 = Hex - D6 = Character - Ö
Decimal - 215 = Hex - D7 = Character - ×
Decimal - 216 = Hex - D8 = Character - Ø
Decimal - 217 = Hex - D9 = Character - Ù
Decimal - 218 = Hex - DA = Character - Ú
Decimal - 219 = Hex - DB = Character - Û
Decimal - 220 = Hex - DC = Character - Ü
Decimal - 221 = Hex - DD = Character - Ý
Decimal - 222 = Hex - DE = Character - Þ
Decimal - 223 = Hex - DF = Character - ß
Decimal - 224 = Hex - E0 = Character - à
Decimal - 225 = Hex - E1 = Character - á
Decimal - 226 = Hex - E2 = Character - â
Decimal - 227 = Hex - E3 = Character - ã
Decimal - 228 = Hex - E4 = Character - ä
Decimal - 229 = Hex - E5 = Character - å
Decimal - 230 = Hex - E6 = Character - æ
Decimal - 231 = Hex - E7 = Character - ç
Decimal - 232 = Hex - E8 = Character - è
Decimal - 233 = Hex - E9 = Character - é
Decimal - 234 = Hex - EA = Character - ê
Decimal - 235 = Hex - EB = Character - ë
Decimal - 236 = Hex - EC = Character - ì
Decimal - 237 = Hex - ED = Character - í
Decimal - 238 = Hex - EE = Character - î
Decimal - 239 = Hex - EF = Character - ï
Decimal - 240 = Hex - F0 = Character - ð
Decimal - 241 = Hex - F1 = Character - ñ
Decimal - 242 = Hex - F2 = Character - ò
Decimal - 243 = Hex - F3 = Character - ó
Decimal - 244 = Hex - F4 = Character - ô
Decimal - 245 = Hex - F5 = Character - õ
Decimal - 246 = Hex - F6 = Character - ö
Decimal - 247 = Hex - F7 = Character - ÷
Decimal - 248 = Hex - F8 = Character - ø
Decimal - 249 = Hex - F9 = Character - ù
Decimal - 250 = Hex - FA = Character - ú
Decimal - 251 = Hex - FB = Character - û
Decimal - 252 = Hex - FC = Character - ü
Decimal - 253 = Hex - FD = Character - ý
Decimal - 254 = Hex - FE = Character - þ
Decimal - 255 = Hex - FF = Character - ÿ