To demonstrate the opposing nature of the CODE and CHAR functions : CHAR « Text functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Text functions
  3. CHAR
Input the formula: =CHAR(CODE("A"))
Input the formula: =CHAR(CODE
22.3.CHAR
22.3.1.CHAR(number) returns the character specified by the code numberCHAR(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 entriesUsing 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 functionsTo 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):If cell A1 contains the letter A (uppercase). The following formula returns the letter a (lowercase):