CHAR()
Syntax. CHAR(number)
Definition. The CHAR() function returns the character corresponding to the code indicated by the number argument.
Arguments
number (required). A number from 1 through 255 indicating the character
Background. Use the CHAR() function to convert the encoding in files created on other computers into characters. You can also use this function to insert nonprintable characters, such as line breaks, into calculated strings.
The CHAR() function is the counterpart of the CODE() function, which returns the code of a character. The character generated for a given code depends on the character set used by your computer.
Example. If you use special characters, such as quotation marks (”), the formula is more complicated. To replace an ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
