MS Excel: CHAR Function (WS)
In Microsoft Excel, the CHAR function returns the character based on the ASCII value.
The syntax for the CHAR function is:
CHAR( ascii_value )
ascii_value is the ASCII value used to retrieve the character.
- 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"|