![]() ii) CODE function in MS Excel is inverse of CHAR function. The behavious of CHR function in VBA is analogous to CHAR function in MS Excel. ¢ - Cent symbol comes from CHAR(162) Please note that i) CHR function in VBA is equivalent to CHAR function in MS Excel. ¤ - Generic Currency comes from CHAR(164) *, ( and ).ġ69 - Copyright Symbol © Currency Symbols: ![]() ![]() Some important ASCII codes helpful in MS Excel:ģ3 to 41 - Special Characters above numbers on keyboard i.e. (Source: Microsoft Office Help)įor example: CHAR(65) would return the alphabet A, similarly CHAR(10) would return new-line. ![]() Use CHAR to translate code page numbers you might get from files on other types of computers into characters. CHAR function: Returns the character specified by a number.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |