ASCII Characters

ASCII is currently the standard for the relationship between a number value and a character type.
Note: The characters 1-9 & 11-31 (?? 128-159) are not supported by Windows

1-9 58:87W116t145174®203Ë232è
10 59;88X117u146175¯204Ì233é
11-31 60<89Y118v147176°205Í234ê
32 61=90Z119w148177±206Î235ë
33!62>91[120x149178²207Ï236ì
34"63?92\121y150179³208Ð237í
35#64@93]122z151180´209Ñ238î
36$65A94^123{152˜181µ210Ò239ï
37%66B95_124|153182211Ó240ð
38&67C96`125}154š183·212Ô241ñ
39'68D97a126~155184¸213Õ242ò
40(69E98b127156œ185¹214Ö243ó
41)70F99c128157186º215×244ô
42*71G100d129158ž187»216Ø245õ
43+72H101e130159Ÿ188¼217Ù246ö
44,73I102f131ƒ160 189½218Ú247÷
45-74J103g132161¡190¾219Û248ø
46.75K104h133162¢191¿220Ü249ù
47/76L105i134163£192À221Ý250ú
48077M106j135164¤193Á222Þ251û
49178N107k136ˆ165¥194Â223ß252ü
50279O108l137166¦195Ã224à253ý
51380P109m138Š167§196Ä225á254þ
52481Q110n139168¨197Å226â255ÿ
53582R111o140Œ169©198Æ227ã  
54683S112p141170ª199Ç228ä  
55784T113q142Ž171«200È229å  
56885U114r143172¬201É230æ  
57986V115s144173­202Ê231ç  

Useful Constants

Chr(8)Backspace character
Chr(9)Tab character (Constants.vbTab)
Chr(10)Linefeed character
Chr(11)Manual line break (Shift + Enter)
Chr(12)Manual page break
Chr(13) + Chr(10)Carriage return - linefeed combination
Chr(13) + Chr(10)New line character
Chr(14)Column break
Chr(30)Non-breaking hyphen
Chr(31)Optional hyphen
Chr(32)Space
Chr(34)Quotation Mark
Chr(160)Non-breaking space


These need to be checked and the FONt confirmed !!!
Computers use numerical values for all data
Text is represented by assigning a numerical value to each letter, digit and symbol.
All computers need to be able to use the same codes
The first widely adopted standard was the ASCII character set which uses the values 0 to 127 to represent the letters, numericals and commonly used punctuation marks and characters.
For example lowercase letters a-z are represented by the values 97-122
The ANSI (American National Standards Institute) code expanded on this by adding (128-255
ANSI is also known as extended ASCII.
ASCII codes 0-31 represent non printing characters.
It was soon realised that the 255 ASCII values were not sufficient for the number of characters that computers needed to work with.
As a result the Unicode standard was created using values 0-65,535
Only 39,000 of these codes are currently assigned
VBA provides functions to work with both ASCII and Unicode
Windows does support Unicode but it will depend on your regional settings.
ASC - returns the ASCII code for a character
ASCW - returns the Unicode for a character
ASCB - returns the first single byte of the Unicode for a character



© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited TopPrevNext