The ASCII code set (American Standard Code for Information Interchange) is a character-encoding standard for electronic communication in computers, telecommunications equipment, and other devices. The list below shows the ASCII codes between 0-127, and the extended ASCII code set, which is part of ANSI standard (American National Standards Institute), with codes between 128-255. ASCII codes between 0-31 represent non-printing characters or control codes, and the corresponding control is shown between <> symbols in the table below when relevant. But computers work with many more characters nowadays. As a result, the Unicode standard with values between 0-65,535 was implemented (only about 39,000 of these codes are currently assigned). Windows supports Unicode characters depending on the regional settings.
VBA provides two functions to work with ASCII/ANSI characters: Chr and Asc. Chr returns the character corresponding to a supplied character code, while Asc returns an integer representing the code for a supplied character. See more about Chr and Asc in this other page: Excel VBA Functions. A variation of these functions can be used to work with Unicode standards for Windows (ChrW, AscW) and byte data (ChrB, AscB).
No comments:
Post a Comment