Using the CHAR function to represent a comma (44) and a space (32) between the two entries : CHAR « Text functions « Microsoft Office Excel 2007 Tutorial






Input the formula: =A1&CHAR(44)&CHAR(32)&A2
Input the formula
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):