Function Reference: CHAR, UNICHAR

Syntax
=CHAR(number)
=UNICHAR(number)
Purpose / Description
Returns a single character text string that contains the character denotes in the ASCII character set (CHAR) or Unicode character set (UNICHAR) denoted by the number given.
Arguments
Name Type Description
number number A constant, reference or nested expression that returns the character code to be generated.  Any decimal portion of the number is ignored.
Return Values
Type Specific Value Description
text string   A single-character text string containing the character whose code was passed to the number argument.
error #VALUE! If the number argument is not a number and cannot be coerced to a number.
For CHAR, if the number argument is outside the available character set, that is, number is < 1 or >= 256.
For UNICHAR, if the number argument is outside the available character set, that is, number is < 1 or >= 1,114,112.
error #N/A For UNICHAR, if the number argument has the value 1,114,110 or 1,114,111, this error is generated.
error   Any errors referenced by arguments are returned due to propagation of error values.
Notes / Comments / Advice / Warnings
Note: CHAR is generally fine for most English language work in text manipulations, The need for UNICHAR arises with the need for the more extensive Extended Character sets in Windows and MacOS that support the complete language set.
Note: Some useful character codes for working with common spreadsheet tasks:
 32 Space character (pressing spacebar once)
34 Quote character (")
39 Apostrophe character (')
48 to 57 Numeric digits 0 to 9
65 to 90 Upper case letters A to Z
97 to 122 Lower case letters z to z
160 Non-breaking space character
Useful Links: About ASCII (Wikipedia article)
Clean ASCII Character Code Table
Unicode Character Table (Wikipedia article)
Examples: Open / download sample workbook: CHAR, UNICHAR, CODE, UNICODE.xlsx
 
Tags: