Char function
Char
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
Example
Formula | Description | Returns |
---|---|---|
=CHAR(65) | Returns the character specified by the number code 65 | A |
=CHAR(97) | Returns the character specified by the number code 97 | a |
=CHAR(163) | Returns the character specified by the number code 163 | £ |
=CHAR(169) | 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: Saturday 25th of February 2023 - 10:13 AM, [Australian Eastern Standard Time (EST)]