This module demonstrates the Excel CHAR function with application to the standard (0 to 127) and extended (128 to 255) ASCII characters.
- SYNTAX: CHAR(number)
- Returns the character specified by the number code (Windows - ANSI)
Char worksheet function
- Characters 1 to 32 are non printing control characters.
- Characters 33 to 127 are the standard alpha numeric set
- Characters 128 to 255 are the extended character set
|Returns the character specified by the number code 65||A|
|Returns the character specified by the number code 97||a|
|Returns the character specified by the number code 163||£|
|Returns the character specified by the number code 169||©|
The Excel CHAR function is not available in VBA, use the VBA CHR function instead.
To return the code of a character, use the Excel CODE function. eg. =CODE("a") returns 97, and =CODE(8) returns 56
- Download the file by using the Microsoft Excel Web App link in figure 1.
- This module was developed in Excel 2013 Pro 64 bit and made available via the OneDrive Excel Web App.
- Published: 13 November 2015
- Revised: Monday 24th of February 2020 - 11:12 AM, [Australian Eastern Standard Time (EST)]