Home
Microsoft Office Excel 2007 Tutorial
Introduction
Editing
Format Style
Table
Chart
Formula
Workbook Worksheet
Wordart Clip Art Shape Picture
PivotTable PivotChart
Data Analysis
Macro ActiveX Add in
Security
Collaboration
Database functions
Date Time functions
Engineering functions
Information functions
Logical functions
Lookup Reference functions
Math Trigonometry functions
Statistical functions
Text functions
CHAR « Text functions « Microsoft Office Excel 2007 Tutorial
Microsoft Office Excel 2007 Tutorial
Text functions
CHAR
22.3.CHAR
22.3.1.
CHAR(number) returns the character specified by the code number
22.3.2.
Using the CHAR function to represent a comma (44) and a space (32) between the two entries
22.3.3.
To demonstrate the opposing nature of the CODE and CHAR functions
22.3.4.
If cell A1 contains the letter A (uppercase). The following formula returns the letter a (lowercase):