MS Excel: CHAR Function (WS)
In Microsoft Excel, the CHAR function returns the character based on the ASCII value.
Syntax
The syntax for the CHAR function is:
CHAR( ascii_value )
ascii_value is the ASCII value used to retrieve the character.
Applies To
- Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000
Type of Function
- Worksheet function (WS)
Worksheet Function Example
Let's take a look at an example to see how you would use the CHAR function in a worksheet:
Based on the Excel spreadsheet above, the CHAR function would return the following:
| =CHAR(A1) | would return "v" |
| =CHAR(A2) | would return "@" |
| =CHAR(72) | would return "H" |
| =CHAR(109) | would return "m" |